Stick with Final Fantasies 4 and 6. And 5. Oh, and Chrono Trigger. For the JRPGs, that is. Oh, and there's the Soul Blazer trilogyesque. Though that's not really RPGish.
I always really enjoyed E.V.O.: The Search for Eden. It's quirky fun in which you control an animal through the ages, evolve, and eventually marry Gaia. Or something. It's just fun.
Flashback: The Quest for Identity is a rather fun platformer. The backgrounds are hand-drawn and the animation is rotoscoped, making it all ever so artistic/fluid. It's always held a special place in my heart.
So has the Lost Viking duo. Three vikings are kidnapped by an evil alien named Tomator on his spaceship. They have to fight their way through scads of levels, solving puzzles, and such. You control one at a time. Olaf is a fat shield dude who can use it as a hang glider. Balog has a sword and a bow/arrow set. Eric can run really fast and break down walls. Each has his purpose in the puzzles and the three have to work together to survive. It's awesome, the puzzles are tough, and there are two of the games.
Can't go wrong with Zelda, dude.