Where is your "conversation" with Master Li after you rescue him, from Jade Empire? I really disliked that game, but it remains a great moment.
"Something-something....IS YOUR GREATEST FLAW!" dun dun duuuun.
Since we're discussing top moments in gaming, I'll throw in my own(in no particular order)
God of War 3 - The Climb to Mount Olympus, and all the set pieces that went into it.
Mother 3 - Sunflowers, or the Mushroom Sequence.
Warcraft III: The Frozen Throne - Ascension.
Bioshock - The Introduction
Mass Effect 2 - Suicide Mission
Eternal Darkness: Sanity's Requiem - Losing your Sanity
Final Fantasy VII - One Winged Angel.
Majora's Mask - The end of the Anju/Kafei quest.
Super Metroid - The Final Boss.
Legend of Zelda: OoT - The Final Boss.
Link to the Past - Entering Dark World.
Elder Scrolls IV: Oblivion - My, you sleep rather soundly for a murderer.
Amnesia: TDD - The moment you scream at pixels on a screen.
The Darkness - It's in the middle of the game, and it is completely brutal.
The Beatles: Rock Band - Entering Abbey Road