Prince of Persia Sands of Time: the ending moment when the prince whispers the secret word to Farah because she didn't believe he time traveled, the word she never spoke to anyone but him, in his timeline.
Warrior Within: Come on, a man fighting against all odds to change his own destiny, even the very beginning when the blind old man tells the prince "Your journey will not end well, Prince. You cannot change your fate.... no man can!" just as they barely saw the Island of Time in the distance.
The Two Thrones: Actually....nothing special besides Farah's death here....
AC2/Brotherhood - Yeah, you pointed it out pretty well, Ezio is built from death and tragedy. That moment when Minerva looked straight at the "camera" as if it was looking straight through your eyes...that pause... and then addressing to you (Desmond of course, not you :)))
Revelations: come on, man, didn't Altair's sacrifice got to you? It was a very emotional moment for me, I was very found of Altair and the way he died was an excellent proof of character considering his past and flaws
The Legacy of Kain is pretty old, I was a kid back then, I think I got overemotional back then, you might be right.
Or maybe I'm a sissy and too much shit gets to me, I dunno, but when i play a game that I truly like my friend, I leave this realm :)))))))