Does Shadow of the Colossus count here? Obviously on a difficulty scale it doesn't deliver but definitely on an emotional level and it remains to this day one of the most memorable final sequences in a game to me.
--
http://gamercards.exophase.com/4831.png
http://i51.tinypic.com/2zpi5w4.png <-- How I look as per Clogged_Artery (Thanks!)