Two times, both brought on by music:
First being the already mentioned fight with Liquid onto of the platform.
Second is from Legend of the Dragoon anytime the "Sh*t got real" music kicks in (anyone who plays this knows the signs: the upbeat meets epic music and Dart giving a quick arm pump or holding up his fist, whichever it was)
Times brought on by just realizing how epic things were:
Prototype. Just Prototype.
Anything in God of War.
In Bayonetta, whenever the developers decide to say that regular action is for wimps and kick things up to 15, most notably, running up a rocket with caved images of angels as it ascends well past the solar system, then beating the boss only to kick them from pluto to the sun.
Assassin's Creed 1: Jumping from the crowd to the platform in which the executions are taking place before he kills anyone and before the guards or anyone can react performing a high profile assassination (alternately, successfully stealth killing any target).
Every boss of Shadow of the Colossus