You're really letting me do this? Really? okay then. Here goes.
Top on the list is the Lost Kingdoms series, 1 and 2. Get them both they're amazing
Secondly is Rhapsody, and earlier title from NIS, who made srpg nerd legend Disgaea
Shin Megami Tensei: Nocturne. Kinda like persona, but i liked it more. PS2
Fatal Frame series: All 4, though the first is my favorite. PS2 except for 4 which is WII
Hey You Pikachu, so much nostalgia N64
Quest 64, the only game i've hailed as having gameplay, battle system, music, and(for its day) graphics so good i could actually overlook the nonexistant storyline.
Harvest Moon is a life simulator. Like the sims but you actually LIKE the characters in HM. Like animal crossing, but you have more to do.
Lets see what else:
Eternal Darkness GC
Clocktower SNES(roms tend to have english patches, since thats pretty much the only way to find the game)
Klonoa series
Animaniacs SNES
Also if you can track down a ps2 headset there's an old game called "Lifeline" that i found fun.
Viewtiful Joe(if you haven't seen it yet)
American Mcgee's Alice
and soon Alice: Madness Returns
Wave Race 64
Space Channel 5 DC
Mystical Ninja N64
Dark Cloud 2(best rpg ever)PS2
.Hack//infection/mutation/outbreak/quarentine PS2
For a more recent title Sonic and the Black Knight for the Wii. Multiplayer is kinda stickytaped on the way spcampaign was taped onto halo3, but the single player is so much fun its ridiculous.
There's also Fragile Dreams: Farewell Ruins of the Moon, a stunning rpg that does an excellent job of looking into human nature. Gameplay isn't the best, but can be overlooked. Also Crow is awesome. This one's for the wii too.
Well i'd stop now but i'd just think of more.
See, already did. Evolution Worlds. Not the best, but an okay gc title.
and another GC title, AMAZING ISLAND. Minigames aren't much, but the character creator is amazing.
For ps2 again we have Graffiti Kingdom. Not much more than a mediocre platformer cellotaped to the most amazing 3d create-your-own-character drawing system i've ever seen.
Lets see now what next. Wizard 101 is an MMO i personally loved.
Hmm what else. Pokemon Mystery Dungeon Sky(maybe not obscure enough but oh well.)
Kings Quest 7. old PC game. No one will disagree on this one.(if anyone has a copy pleeeese let me know, i've been wanting this game forever. I miss it so.)
and since this is getting long i'll leave you with somethings from the days of shareware.
An old dungeon game called Haven, made incredibly difficult, to the point where it is entirely UNFAIR AT ALL, ask anyone who's played it.
An old in-depth DnD style RPG that was RIDICULOUS in everything it did, from the amount of ways to create your character, the stat and guild system, the traps in the dungeon itself(stay away from studded tiles, those things are BAD NEWS, same with water if you aren't quick). Really tough because your team autofights when a hostile enemy is near, and in that same way if you don't think quick you'll either die or drown or something. Oh and the identification and selling of items is pretty well done too. Mordor 1.something
Or if you want a more traditional turn based rpg with what would be considered these days utterly stupid(note stupid is good here) levels of customization and a wide world and amazingly fun story, There's Exile 3, Ruined world.
or if you feel like something more casual for half an hour, Quenzar's Cavern was also really fun.*hisssssssss* hehe
I'll find some links here if i can.
Exile 3 http://www.spiderwebsoftware.com/exile3/winexile3.html
Can't find haven. I got it off an old disk called '1000 best games for windows'
Mordor: http://mordor.uni.cc/forum/index.php?automodule=downloads
Quenzar's Cavern http://www.demu.org/pages/view.php?ref=4939&search=man&order_by=random&sort=ASC&offset=74&archive=0&k=