Oh, man. That's the Escapist for you. See, when MOST people hear the phrase "leaving your comfort zone", they'd think "skydiving" or "bungie jumping" or something crazy like that. I, personally, thought of getting wasted. But what does the Escapist think about? A new videogame. Gotta love it. Not insulting anyone, or the topic, I'm just saying the title is a bit misleading.
Anyway, my favorite out of those is Uncharted 2. But if you really like RPGs, I'd go with Fallout 3. No garutee your hatred for FPSs wont ruin it for you, though. Seriously, it's a very shooting-heavy game, and VATS only helps so much.