For me, I say it's a tie between inFamous and Uncharted 2. Loved the Shyamalan twist at the end of inFamous and the spoiler (click to show/hide)
dialogue (clowns) between Nate and Elena
at the end of Uncharted 2 was priceless.
Uncharted 2 had a pretty terrible ending. The game ended and didn't put me in the mood of wanting to play more.
Infamous' high point for the story was the ending, but only because it was a good tease for the next game. spoiler (click to show/hide)
They essentially show you what powers you will have and main enemy you will face.
It's probably between Assassin's Creed 2 and Dragon Age, but since not everyone got the same ending as me in Dragon Age, probably AC2. The entire sequence of spoiler (click to show/hide)
trying to assassinate the pope, fighting him with magic clones, having a fistfight in an underground secret room of the Vatican as the pope disregards religion, and finally, the game takes a dump on the player by revealing the entire purpose of both Ezio (and Altair, other members of the bloodline) were just tools to carry a message on to Desmond. Awesome stuff.
Actually, FEAR 2 and Bionic Commando are hilarious too.
About AC2:
spoiler (click to show/hide)
The pope fight was dragged out to the point of becoming ridiculous, though. How many times did I have that guy one good stab away from death? And to make it worse, my own buddies let him go, and claimed that it didn't matter. Right, you clowns.
That whole bit made for some cool scenarios, but it was still ridiculous.
fear 2's ending is so fuckin' awesome :lol :bow2
spoiler (click to show/hide)
at least you get the girl in the end!