Hahaha! A Dance With Rogues ...
And STALKER is an RPG hybrid now?
Anyway if you liked something a bit more combat oriented, you can try the two Icewind Dale games, The Temple of Elemental evil and the very recent Knights of the Chalice. It also depends on what bugged you with Oblivion because maybe Morrowind might be worth a try but be aware that the exploration is the best part of the game, with a very rich and alien world, something Oblivion failed at, while combat and conversations are lackluster.
Divine Divinity is also pretty cool. It starts off as a Diablo clone but after you leave the first village (and the first dungeon), the game has a lot more to offer. Starting and ending areas are boring but the huge middle part is good.
As for Neverwinter Nights, the OC is (b)anal/shit/boring, Shadows of Undrentide is decent but not very special, Hordes of the Underdark is nice but not terribly special either. NWN 2 OC is a decent generic fantasy romp but again not really special, but Mask of the Betrayer is probably the best CRPG that came out these last years, you can even bypass the OC and jump straight to the expansion if you wish. Oh and Storm of Zehir has some good ideas but a questionable execution at times, I found it fun but it might not be to everyone's taste.
Like dungeon crawling? Try Wizardry 8!
Else you can go look to older games, like the Realms of Arkania serie, or maybe even Might & Magic III, IV and V.