Beating up Bowser in Super Mario 64, and later getting all 120 stars.
Throwing proximity mines everywhere in Goldeneye.
Putting landmines in front of peoples' treasure chests in the banana (so that they'd lose their cargo, and be very mad) mini game, or pulling people into the water trench with the magnent in the same level of Diddy Kong Racing. Also, there was something very satisfying about shooting someone with a rocket right after they picked up their egg in the volcano level.
Running down the collapsing castle in Ocarina of Time.
Shooting some of the ultimate weapons in Turok Dinosaur Hunter.
Some of the bigger battles in Star Fox 64.
And... beating up (and getting beat up by) my friends in Super Smash Bros.