The stabbing scene in Private Ryan
Heartwrenchingly unwatchable, in a good way, in a great movie.
I'll add the fingernail ripping out in Syriana. Mainly thanks to whoever did the foley, and seemingly studied exactly what that would sound like.
And any Keanu Reeves part involving an accent.