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.