Knights of the Old Republic
Baldur's Gate series
Neverwinter Nights series
(coming soon) Mass Effect

Other than Mass Effect and Neverwinter Nights 2 (+MotB), there aren't really many RPGs that are graphic and gameplay heavy.

And just as a forewarning, keep Mass Effect copyright BSing out of this thread. We have a thread dedicated to that discussion already.