I'ma start with Planescape: Torment. It's one of those dreaded 2nd edition AD&D Infinity Engine games, and it's one of the most heartwrenchingly beautiful things ever written for nerds who think in hit points. Don't like the isometric RPG style of gameplay? Play it anyway; the lackluster game mechanics are more than made up for by the unique, atmospheric setting, the desperately flawed and sympathetic psychopaths that hover around you, the sad and romantic storyline... the... well, everything. It shines lucent genius in every artistic department. If the opportunity ever presents itself to you to play this game, take it, it's gorgeous.
I'm convinced Katamari Damacy is one of the most potent natural cures for depression. You feel bad, you roll up everything into a tight little ball of love, and the theme song gets stuck in your head for seven months. Hurrah!
Everyone who plays and enjoys RPGs should have played Earthbound by now, if only for the cute and quirky reflection on the genre. Oh, and if anyone out there loves Earthbound and has a DS, you may want to look into a game called Contact; the design is very similar.
And speaking of old-school SNES RPGs, I'd like to take this space to mention Seiken Densetsu 3, one of the most eye-poppingly gorgeous things that little old system ever produced. It takes the pixels and turns it into pointillism, and apart from how pretty it is it's a damn fun game as well.
And in the realm of things you can check out right now, we have the Kingdom of Loathing (at www.kingdomofloathing.com/ ) and Geneforge (at http://www.spiderwebsoftware.com/geneforge/ ). Geneforge is a clever little shareware RPG built by old-school-styled guy-in-basement game company Spiderweb Software, and has one of the more unique and interesting twists on the standard fantasy genre I've seen, putting you in the position of a Shaper, a member of a secretive and dominating magical sect who controls most of the known world through their ability to make and manipulate life. And as for Kingdom of Loathing, it's just hilarious.