Bishoujo Senshi Sailor Moon: Another Story - Angel (1995). An RPG in the style of the SFC Final Fantasy games, with a script and plenty of original characters created by manga author Naoko Takeuchi
Kimi no Yuusha - SNK (2008). A DS RPG that offers bite-size quests for today's busy adult gamers. Character design by the same artist as Twinkle Sprites: La Petite Princess.
Shining Ark (2013) - Sega/Media.Vision. One of the many Shining games with art my Tony Taka. This is one of the better ones (relatively speaking) with an SRPG battle system similar to Valkyria Chronicles
The Saturn Devil Summoner games also had companion Akuma Zenshou discs. These are high res illustrations of some demos, nicer looking than they appear in the game