Tincow pretty much listed all of the good classic RPG style ones. Oblivion should be thrown in there too, but has a drastically different playing style from traditional RPGs and even Morrowind to an extent.

I've found it pretty dissapointing that that small list there contains every top notch RPG in the past decade; I guess they just don't sell as much as other genres, FPS especially