Chrono trigger, FF5 and others pretty well known would be an easy answer (this including the SMT his spinoff series), so, with easy choices cast asides, I guess it would be...
Fate/Extra
getting advantage for trying to know more about your enemy is something that I absolute love, tho I don't like how you unlock the noble phantasm, even if it's a good way to tie the story with the mechanics.
The Adventure of Hourai High School
The characters are in the fine line of being weirds to be absolutely mads, which is kinda perfect considering that the graphics is like Metal Max and Mother.
Jojo's Bizarre Adventure: The 7th Stand User
Ok, with this one, I'm cheating. It may be a JRPG, but isn't official, is a fangame. But boy, oh boy, is so damn good. The fact that there's a good nomber of original stands for the protagonist (which you can name and select an appareance of a pre-made ones) and the battle system is, muah, perfect.
Sailor Moon: Another Story
Tbh, I didn't play this that much, but I love Mahou Shoujo, so be sure I'll be playing it today a lot lol
The Madou Monogatari Series
Well, this is for the same exact reason, but I did actually beat some of the games of this saga. I don't suffer from Motion Sickness, but even so, the movement makes my eyes hurt a little. Even so, totally worth if you're searching games to fill that hole in your heart that a not-so-mahou shoujo series did, if you want something funny but not so violent or gross to play with your nephew/niece (BE CAREFUL, the first version of the two/three games from the Madou Monogatari did actually have some pretty gruesome gore, so pay attention to which version you're actually downloading), or if you like the Puyo Puyo Series.
Metal Max
Well, this is the last one I can think of, and is kinda cheating too, because it's well known. But the "structure" of this game is kinda despised or/and forgotten.
If you don't mind a more inmersive experience at the cost of some unfair events and fights, then this (and dwarf fortress, go play dwarf fortress) is for you. Even at the beginning you gotta grind a bit, which if you like it as much as I do, your (probably fried) neuroreceptors will have a good time seeing how numbers get big and you kill more awful creatures that their only sin is to try to live in a world where you exist(such a dumbass lmao), and farming the lvl and stats of some people that are an excuse of a friend, and more a new vessel or slave to unleash the inner anger of the god of chaos that you will incarnate.
Also, I like carr, carr funny, can shoot inside a carr
carr
Pium pium, carr.