Until you see this:

The Moment: George Kirk becomes a hero

The Moment: "Let's get the hell out of here."

BTVS Season 2 Finale

The Moment: When the T2000 leaps on to the helicopter. Morphs into the hole in the windscreen, reforms into a silver cop, and says "Get out".

The Moment: Obvious

THE MOMENT: "You shall not pass!"

THE MOMENT: The very first dinosaur reveal.

For me one of the greatest nerd moments for me on film is possibly this shot of the Avengers from their first film:

The moment: "You blew it all to hell! God damn you, you blew it all to hell." Taylor realizes he's been on Earth all along.

"All those... moments... will be lost in time, like... tears... in... rain. Time... to die..."

Star Wars opening scene

The Moment: The death of Spock

Still waiting for that hat to show up in the narrative. lolz

Captain: Tywin Lannister

I like this game.

Let's see:

I would pay real money to watch Captain Reynolds and the crew of the U.S.S. Serenity.

And then there is the Brotherhood without Boners.