For me it would be the door opening in Zelda: Twilight Princess. Seems like it took forever.
The other would be from Halo: Reach and Assassin's Creed II - where I had to start over many times cause I kept dying. (wish I could skip after like the 5th time.)
Halo: Reach - at the end of 'New Alexandria' when something unpleasant happens. The scene right after talks about it and I went from sad to angry.
AC2 - with the glider thing from Leonardo.







