Baldur's Gate 2 Neverwinter Nights 1 Gothic 2 TES 3: Morrowind Divine Divinity The Witcher (definitely the best RPG to come out since 2k2) Evil Islands (simple but great gameplay)
and for the future, I'm putting my cents on Divinity 2: Ego Draconis and Dragon Age: Origins at the moment.
It's kind of hard to still say what an RPG really is though. If System Shock is an RPG... what isn't an RPG? The Thief games are definitely more RPG-like than System Shock, but they aren't, because there isn't really much character development, and there isn't really a different path, or different role you can play. If you play a game and you have to spend it shooting (or robbing) pretty much everyone; then it's not an RPG . I consider it Action Adventure/FPS. If you want to see an Action Adventure with a great story and the best dialogue and voice-acting ever, check out Legacy of Kain: Soul Reaver 2 and Legacy of Kain: Defiance. They are incredible games.