I'm sure a topic along these lines has existed before my time, I see none currently running. I'm always interested in what other people view as the most amazing movie scenes, or in cases like me, game scenes. A scene that shocks you to the core, or tugs at your heart.
My particular interest with things of this nature stems from the fact that I am a music composer, teacher, performer, and have also been working on my own fantasy novel for more than a decade. As such, I'm always curious as to what things most moves the masses. My goal is to not simply write a story for you to read. It's to craft one you can feel.
So, without more of my blabbering...
3:10 to Yuma and The Prestige both end with a punch to the gut. I do enjoy being doubled over from movies like those.
As for games, MGS 4... I found it very difficult to pull the trigger on The Boss.
Have at you.
I realize after posting that this is probabley better suited to the discuss movie forum.

