I just picked up Beyond Galaxyland in a Fanatical bundle. I have not played it yet, so tentative recommendation, but reviews are indicating it may be a hidden gem.

For an older one I really liked: Cosmic Star Heroine. Pixel art, great soundtrack especially for bosses, and fantastic combat mechanics. It’s all very uniquely designed to encourage high-risk gameplay and variety on every turn, pushing moments where you buff yourself up for one or two supremely powerful strikes in a fight, or even sacrifice a character to KO the last enemy (all characters heal to full after every fight)

For even older: As someone who had that same kind of music-swelling nostalgia around FF7, I managed to win back that feeling when I played “The Legend of Heroes: Trails in the Sky”. It’s a two-part game (sold as two units), that begins a giant series of games, but I only played it out of curiosity. Even though I didn’t fully enjoy later games, Trails had both a lot of enjoyable and unique elements to its combat, and a very emotionally written story that occasionally throws in silliness to retain charm. Though the game itself is old, it got a series of patches by a “master porting engineer” at Falcom that adds features like an experimental fast-forward mode to help with long battle animations.

On grinding, one great thing about the games is their XP system. They grant a lot more XP anytime you’re underleveled for enemies, and much less when you’re overleveled - helping to equalize the experience after just a few fights, many of which can be short thanks to fast forwarding. But, the story is still long overall.

You’ll see a Trails 3, which is very optional in my view. Weirdly, it’s a bit more of a “lore dump” for future games than closing off any major plot threads. To me it was a little bit of a signal of them taking their “Marvel universe” style of world a bit too far.