I would suggest Risen as an RPG you should check out. It's a recent game (less than a year old) and yet very old school.
It's the sort of game that really, really creates an atmosphere. If you have a decent rig, the graphics are very nice. All dialog is voiced, and the acting is great.
It reminded me of the Ultima games in that there is a complete free roaming world, day/night cycle, and NPCs that actually keep to a schedule and don't stand in one place 24/7 as quest dispensers.
The combat is not a clickfest, either. You have to level it up and get used to it, timing your attacks and dodging, parrying, blocking, etc.
It's far more fun than Oblivion. Nothing is level-scaled. If you wander into the wrong place when you're low level, you'll get your ass handed to you right away. Better loot and upgrades do not fall, Diablo-style, from every monster and tree. Wolves do not drop plate mail. You have to work and quest for your upgrades, and you get a damn fine sense of accomplishment from it, something sorely missing from Oblivion and other level-scaled games.
I'm enjoying the hell out of it.