It comes down to what style of RPG do you want to play? Western (US and UK) or Eastern (Japan)? I will only list the ones I think might be worth some time (I play more of em but I can tolerate meh games).
Western Style
Skyrim
Oblivion
Fallout 3
Dragons' Dogma (listed here as it is a bit more like a western rpg)
Dragon Age Origins
Mass Effect 1
Eastern Style
Eternal Sonata
Lost Odyssey
Star Ocean: Last Hope
Resonance of Fate
I'm going to list another category here because it is a blend of RPG and Action, and that is Adventure. Faster paced than RPG but still fun. It seems to be primarily a western focus on the Xbox. These are also your Zelda games, but eastern game developers don't bring them to the Xbox much (PS3 is the Eastern RPG/Adventure system.) These can get a bit repetitive since some RPG elements are misused in Adventure games.
Western Adventure
Fable 2
Kingdoms of Amalur
Witcher 2 (I haven't played it yet so I have a hard time placing if it's an Adventure or RPG)
Darksiders 1 or 2
Marvel Ultimate Alliance 2
Dark Souls (Eastern done somewhat Western but done very well, and hard, something Western developers don't typically like to do)
Mass Effect 2 (when you take out the dice rolling of combat and make it skill shot you take enough "RPG" out and make it an adventure)
Also, if you want to learn more about the RPGs out there and want to avoid IGN, Gamespot and the other types of reviews go to
http://www.rpgamer.com/. They have been around since 1998.