I know I'm probably going to get a lot of "jokes" about the title, but that was the easiest way I could think of describing the feeling I want to ask about.

So you know when you were playing Fallout 3, and you'd spent the first 10-15 minutes (at least?) inside the vault, and then you step out into the daylight the first time? I'm pretty sure they did some image processing to reinforce that feeling, but I got goosebumps at that point.

Or another example being in Bastion near the end if (when) you decide to save Zulf and how his tribe deals with it.

Or another example being likely totally dependent on nostalgia, thus a bad example, but how intros to Monkey Island games start at sea, and then have the island, and just as the musical cresendo hits you get your DEEP IN THE CARIBBEAN line.

Or a non-gamey example being something like this game trailer.

Now I'm trying to describe a very specific reaction that occurs, definitely not just simply "I thought that thing was cool!". Most of my examples were narrative-based, but it doesn't have to be restricted to narrative (I just can't currently remember a good other example).
The best way I can think to describe it psychologically is that the game sets you up in a specific engaging pattern plateau or even slowly elevating ramp, and then at one point almost instantaneously, often through a build-up of a combination of interactions, gameplay, ambience, music, visuals, just...raises the bar and whams you completely.

Have you got other examples in games of situations that result in that sort of physical reaction in you to something that is purely mental? I don't think I did any spoilers here (maybe Bastion a bit), but try to keep it spoiler free as well!