JesterRaiin said:
If you can see past old graphics then...
Drakensang isn't that bad.
http://technopolis.polityka.pl/wp-content/uploads/2010/12/drakensang04.jpg
I was quite happy with The Fall : Last days of Gaia.
http://2.bp.blogspot.com/_aTOHk6mTSXs/TOVHzdlxWJI/AAAAAAAAPxU/_Gk4qPY0hSY/s1600/Foto%2BFall%2B%2B%2BLast%2BDays%2Bof%2BGaia%252C%2BThe.jpg
Arcanum is worth trying
http://img.jeuxvideo.fr/photo/02025488-photo-arcanum-engrenages-et-sortileges.jpg
First I've heard of The Fall...
Anyway, I'll readily second Arcanum and Drakensang.
Drakensang is a must if you do really enjoy NWN2. It's in an almost identical vein, but it's also... well, really damn goofy at times. Some of that is translation (the game was originally German, and there are a few translation glitches scattered around), but it has a distinct flavor, and can actually be quite challenging at times. There's also a stand alone expansion, Drakensang The River of Time.
On top of that, I'd add the Gothic series, 1 and 2 anyway, and Risen to the pile.
Two Worlds is a bit of an acquired taste. The original has some downright hilarious dialog, it's consistent, but it's not quite English. This can either be charming or irritating depending on your preferences.
Titan Quest is a personal favorite in the Diablo mold. Though it has a reputation for bugginess that came from a botched crack of the DRM. Torchlight's another really excellent Diablo clone, and for a lot of people that's the one they gravitate to.
Warhammer 40k Dawn of War II is an RTS in theory. In practice it's actually a multi character action RPG. The story is as over the top as the 40k name indicates. So if you have a hatred for that property, then this one is a pass. Otherwise, this should be high on your list.
Winter Voices is... well, it's interesting. Yes, good interesting. I didn't get far with it, honestly, but it's a turn based RPG dealing with a character's grief. It's interesting at least as an intellectual exercise in evaluating how abstractions in game mechanics can be applied.
Vampire The Masquerade Bloodlines is in the Deus Ex route. It's a must play, but you might want to track down the user made patches, which bring it up to snuff.
Steam bizarrely categorizes Terraria as an RPG, but I cannot recommend this game strongly enough. It's a minecraft/metroidvania hybrid. It's also 5 bucks.
Saints Row 2 isn't an RPG per say. There are RPG like unlocks for certain milestones, but it is an excellent GTA clone.
Saints Row 3 cuts some features but shifts over into full on RPG elements. If you're not a fan of GTA style games, I can't really recommend either of these, but they are both worth mentioning.
Borderlands is a Diablo clone/shooter hybrid. It has a slight bias towards the shooter elements in gameplay, but with loot collection as a key feature. It can be a lot of fun, particularly in coop, but, it can also drag a bit in solo play, if you're not a big shooter fan.
Divinity 2 is interesting. It's a sort of linear game, and it is unrepentant about slaughtering the player. I kinda can't remember why I stuck with it for as long as I did, but I do remember enjoying my time with it.
If you're a fan of Oblivion and Skyrim, it might be worth taking a look at Morrowind. It has a few features later versions dropped, like the dice roll on your attacks, and blocking being a passive chance. On the other hand it is easily the most engaging and alien environment in the series with one of the best main quests I've seen in an Elder Scrolls game.
Eschalon is a rather unique game. It's a very old school turn based RPG. And by "old school", I mean, the game will gleefully screw you over for build mistakes. However it is a pretty rewarding experience, so it may be worth a look, and I think there is a demo.
King Arthur - The Role-playing Wargame is NOT an RPG. It's an RTS in the Total War vein. That said the RPG sequences are rather neat. It ammounts to something slightly more advanced than a text based choose your own adventure, but it is an interesting experience, and again, yes, I do mean interesting in a good way.
Champions Online is a free to play MMO, so, that may sink it right off the bat for you. Still, if you have a fondness for superheros, or want some utterly insane costume customization, this is one to take a look at. New content tends to be free, though there are three "adventure packs" that are gated behind a subscription or paying 10 bucks for each, once. Subscribers get $5 in free money per month. Subscribers also get a freeform character creation system, that is really mind blowing in it's options. I've seen boxed copies of CO from back when it was a subscription only game, and those will give you 30 days of game time for 10 bucks, instead of the 15 normally charged.
DC Universe Online is another free to play Superhero MMO. It honestly plays more like a console brawler, and some of the restrictions on free players are a bit punative, however, there are multiple options on subscriptions. However, new content that's being added tends to be in the DLC model, requiring you to either be a 15/mo subscriber, or buying the content outright.
Not on Steam:
Escape Velocity is an RPG in the Elite tradition. Sort of like Mount and Blade, but in space. I believe the only EV game released for PC is Nova, and last I checked it was still full price ($30), but Escape Velocity is a pretty solid starship RPG. It can be purchased from Ambrosia Software [http://www.ambrosiasw.com/games/windows/].
On Steam, but wait:
Star Trek Online is going free to play next month. If you want to get in before F2P hits, it might be worth a look see, or not. There've been some pretty serious system overhauls that have pushed a lot of players out of the game. But, at it's core, it puts you in command of your own starship from the tutorial on, and sends you out to complete missions. It's got issues, but, I'm not inclined to write it off entirely. Like CO it does give subscribed players five bucks worth of in game cash per month, though unlike CO, there are more sinks for this that directly effect gameplay. It's not pay to win exactly, but it is pay to avoid grinding for some things. If this is offensive to you or not, could be a deciding factor.
Anyway, I hope some of these help.