Final Fantasy 6: Yeah I too could just cheat and say "The whole game" but instead I'll touch on a section of the game no one else has mentioned yet.
Spoiler Below The Opera House scene, you know what I am talking about.
Ace Combat 4: Shattered Skies.
Spoiler Below The Final battle against The Megalith.
The final mission of the game has you leading your squad of fighter jets in all out assault against a giant laser cannon while an awesome orchestral score blares in the background.
Metal Gear Solid 3: Snake Eater.
Spoiler Below The final fight against The Boss. This one on one classic confrontation between student and teacher, is one of the most emotionally charged fights in all of video gamedom as you and her duke it out in a visually stunning field of white flowers engaged in a winner take all duel to the death.
Shadow of the Colossus
The rush you get when you take down your very first Colossus....which is quickly dashed when you realize that there are several more of those bad boys left to kill.
Phoenix Wright: Ace Attorney
Spoiler Below All of case number four where you have to defend your rival "Miles Edgeworth" who is on trial for murder and the man who is prosecuting him is the demonic "Manfred Von Karma" who was Miles' mentor/father figure.
Phoenix Wright: Trials and Tribulations
Spoiler Below Case number five, where you actually get to play as Miles Edgeworth as he fills in for an injured Phoenix as the defense attorney.