The end of Red Dead Redemption definitely got me misty eyed, the song at the end being a nice touch. Definitely one of the few times I've been legitimately moved by a game. Pretty much...
Mass Effect 3 ALMOST got me there, and then...well, not to belabor the point, but any emotional...