I don't even get why people hate ME3.
Does the last 5 minutes of it make the entire game awful, really?
HOLY GOD WHY AM I AGREEING WITH MADS, BUT THIS IS 100% TRUE
ME2 and ME3 were both AMAZING games, easily my top 3 out of the 10. I don't usually have the patience to do RPGs, but Mass Effect 2 and 3 managed to hold my attention and keep me loving it the entire time. I don't give a crap about the ending, because to me it's about how much fun I have getting to the ending, rather than the ending itself.
That being said, I already said I don't play a lot of RPGs.
Deus Ex: HR was fairly good imo.
Skyrim was also very enjoyable for me. I dunno what you guys are talking about Oblivion for though. Oblivion was turrible. Turrible combat, terrible character gen, terrible voiceacting. The story was literally the only thing good about it. The one thing that made Oblivion good is mods.
KOTOR1 & 2 goes without saying, because I'm a gigantic Star Wars fan. Also, SW:TOR's story was basically RPG, so I'm gonna be naughty and list that.
That's basically my list of RPGs I actually played consistently and didn't get bored of.