There's the good ol' Baldurs Gate games, Neverwinter Nights 1 & 2. There's the Icewind Dale games.
Newer games include Might & Magic: Dark Messiah (really cool) Obviously there's oblivion, but I'd have to say that it pales in comparison to the previous Elder Scrolls games.
An older game I enjoyed was Return to Krondor. The camera is a bit....weird, but the game itself is quite good.
There's Titan Quest, a diablo ripoff, but still quite entertaining.
Another older game is Arcanum, quite good also.
