i think this is a little bit different, but once i went on a rocketship ride in my girlfriend's rocketship, on WoW, i was new and she was flying me around, i had smoked a lot before and everything looked so beautiful

Bioshock. When you learn the truth of who/what you are and then the good ending with the little sisters.
2nd where you come so close to saving her only to have victory snatched away and again the ending, very emotional.

Expecting bioshock infinite will have something like this, I suspect it'll be a choice scene where doing one action will make the boss even harder but you did the right thing. Or you'll do the easy option but feel the pinch later in the game.

Prey. Tommy fights through alien abduction, insane puzzles and even death, only to have to kill the very thing that kept him living and kept his rage at bay. A bitter sweet victory.

Final Fantasy VII...I don't think I have to explain why, everyone should know this one by now.
Never before did I have such a desire to totally annihilate an end game boss.
Never before did I feel "real" hatred for a videogame character.

After Cid dies in FF6 when Celes goes up onto the mountain. In FF7 when she dies. Mass Effect 3 when Thane passed away. The end of Legend of Heroes: Trails in the Sky. FF10's ending always gets me, even just watching the cinematic on youtube like I go back and do every so often.