The tibbits scene from "Condemned". That scared me pretty badly. It's not for the faint of heart and sticks out in my mind. You can check it out here: http://www.youtube.com/watch?v=z60GiodETE0&feature=related Also, in case you're wondering, the reason his face looks like that is because his lips were cut off.
Also, the ending to "Shadow of the Colossus" which can be viewed here (it's in 3 parts): http://www.youtube.com/watch?v=fxKN77TSags
http://www.youtube.com/watch?v=OzE0lD8uQGw&feature=related
http://www.youtube.com/watch?v=ffqdukNjaus&feature=related
That was a work of art. The main character has spent a long time trying to resurrect his dead love and now he's just trying to get to her, watched his horse fall (enough to believe that it died), he has been battered, bruised, cursed, and is in pretty bad shape, and then, this happens:...just watch it. Trust me, it's worth the time.