What are some moments in all of Trek that just makes you go Heck Yeah? One of my all time favorites is when the Cardassians turned on the Dominion in that final battle. Also when Kirk orders "Fire" in STVI and that torpedo homes in on Gen. Chang's ship. When Kirk gives Khan the "Genesis Information" When 8472 takes out that Borg planet like it was swatting a fly, not sure I say Heck Yeah, but I did say HOLY CRAP! DS9 defending against the Klingons in Way of the Warrior.
The Romulan's decloaking to Join tnhe Federation and Klingon Forces, when Cardassia joined the Dominion. The Klingons coming out of the sunlight to attack the Dominion Forces in "Sacrifce of Angels"
The classic Jerry Goldsmith Star Trek piece with the Borg undertones in the Paramount opening signature in First Contact... Seeing the name Patrick Stewart on the big screen in the opening credits of Generations. Sulu's "target that explosion and fire..." command in The Undiscovered Country. Seeing the Enterprise D on the big screen for the first time, even though I prefer the Enterprise E over all Enterprise named ships. Finally, hearing the Klingon theme and seeing Klingons at the beginning of The Motion Picture.
Picard's "that will be the day" response to a demand for surrender in "Yesterday's Enterprise" Captain Jellico's whole final exchange with the Gul in "COC," first with the "the next one will be on your belly" or something like that, and his "I expect him returned immediately." Jellico may have been a lousy captain, but he was an effective bad-ass.
I only agree with him being a bad-ass. He was also a good captain. Just different from Picard. But that's a discussion for a different thread. As for this thread: Enterprise slowly rising up behind Reliant in the Mutara Nebula. "Don't call me Tiny." in TSFS. "This is fantasy," in the same flick.
Sisko punching Q. Janeway nearly destroying Voyager just to get those experimenting people off the ship. Picard telling Wesley to man up in the First Duty. Data telling Lt.Cmd. Hobson to quit being a little whiney biznitch. (I paraphrased of course)
Sulu's "Target that explosion and fire." and Kirk's "Fire!" in 'TUC'. Riker ordering the topedo fired on the Bird of Prey in 'GEN'. Reliant's port warp nacelle being blown clean off the pylon in 'TWoK'. Kirk offering to save Nero and his crew and his subsequent exchange with Spock before firing everything thing at the stricken Narada in 'Star Trek (2009)'. The Defiant and the Fleet vs. the Borg Cube in 'FC'. Dukat walking into Sisko's abandoned office, seeing that the baseball is still there, and understanding what that meant. And the subsequent reveal of the impressive Starfleet armada at the end of "Call to Arms" DS9.
Spock's little exchange with the Vulcan Science Council in ST XI, particularly his final, utterly venomous "Live long and prosper."
The Defiant linking up with the huge Federation/ Klingon fleet in Call to Arms. It's the first time we see a huge Federation fleet, ready for war onscreen, the music said it all.
Duras at the edge of the expanse telling Archer to surrender, and Archer telling him to go straight to hell, without missing a beat. The NX-01 getting beaten to a pulp by the Xindi ships... crewmen sucked out into space and all.
Kirk punching Kang in Day of the Dove. Now before I put you in the brig, here's a little something I owe you - *SMACK*
When Mirror Spock beat the baloney out of Capt. Kirk in 'Mirror, Mirror'. That moment had me cheering my butt off.
And the very next episode turned that on it's head by showing part of that same fleet limping home shot all to hell and back, which was very effective in grounding out the "heck yeah!" and replacing it with "Oh Crap!"