My big 3 on that system were Chrono Trigger, Earthbound, and Mario RPG, in no particular order (though I generally lean toward Earthbound). I would throw Zelda: A Link To The Past as an honorable mention (not an RPG in the same sense of course). All classics and worthy of respect in their own light

I love the cognitive dissonance that this produces.

Earthbound will always be a top game for me.

I’m hoping Star Trek Infinite is going to be great. It would scratch a bunch of itches if it’s done well.

https://www.paradoxinteractive.com/our-games/star-trek-infinite

To add to this, there’s a decent chance you’ll like the game enough to buy some of those DLC’s at some point, just to support the awesome devs.