Pacific Rim. Most of it, especially the fight sequences. Two in particular that stand out would be when they bust out the sword, and when what's-his-face uses a goddam oil tanker to beat the living *&^% out of a colossal monster.
The Dark Knight. I'll always remember, I saw it opening night, and I had one of the best seats in the theater. Then the pencil happened. 300+ viewers, all at once, one great big "Holy shit".
Ni No Kuni. The first boss battle. 99% of the battles are against adorable little creatures that, in time, can be made into minions. Then suddenly, giant goddam earth elemental.
Solforge. A card game made me say "holy shit", and not for a good reason. Some creatures are just hugely *&^%ing overpowered. Like, there are strong creatures, and then there's "holy shit, *&^% this game." I know there are ways to defeat these creatures.. provided you have the right card, at the right level, and the game randomly deals you that right card at the right time. It doesn't matter how good your deck is, sometimes the heart of the cards is just not on your side, and you're destined to get shafted.