Robotrek was made by Enix and it doesn't suck.
Play that. And:
Crystalis
Brain Lord (well..maybe)
Arcana
Soul Blazer
Tales of Phantasia (there is an excellent English ROM translation available)
Terranigma (ditto)
Mario and Luigi
Final Fantasy Mystic Quest (I don't care if it's simple and the story sucks, I like the game)
Chrono Cross
The entire Breath of Fire series
The entire Star Ocean
The entire Suikoden series
The entire Ultima series
The entire Lunar series
The entire Lufia series
The entire Ys series, most of which should be available in ROM form (various old systems)
All the Game Boy Final Fantasy (actually SaGa) games, plus Final Fantasy Adventure aka Seiken Densetsu 1.
Secret of Evermore
Parasite Eve 2
Panzer Dragoon Saga if you can find it
Star Ocean
Kartia: The Word of Fate
Ogre Battle
Tactics Ogre
Alundra
Grandia 1 and 2
Xenogears
Xenosaga
Pokemon (no, really)
Legend of Legaia
Vagrant Story
Brave Fencer Musashi
Jade Cocoon
Legend of Mana
Valkyrie Profile
I've finished a third of these, played another third, and heard good testimonials about the rest. If you manage to find all of them, they should last you a few decades (plus a bunch of them have sequels or will have sequels by the time you get around to them).