Galuf in the Sealed Forest in FFV (although its somewhat less badass if you enter into that sequence as a White Mage).
Hell, Galuf in general is king badass what with being a world saving hero, flies around in a meteor, storms a castle single-handed to save the rest of the party, and then there's the stuff in the Sealed Forest plus the stuff that he gets in with the rest of the party.
his sacrifice somewhat less badass as you get someone with the exact same powers and skills like 2 minutes later.
my moment, probably the shootout in red dead redemption, you guys know which one.
To be fair though, given that the game's character development system basically required having all four party members with you for most of the game so that nobody falls behind in Job development, the fact that they killed anybody off at all was a pretty ballsy maneuver.
I mean, compare with Dragon Quest VII where you lose Maribel for a significant portion of the game and is replaced by Aira and the only thing Aira has coming into the party is a couple levels in Warrior and maxed out Dancer (which is the fastest class to max out in the game so its not even that big of a deal). By the time Maribel comes back, not only has Aira probably surpassed her in class levels but she can only get on the team if Gabo (aka the only guy other than the MC to have stuck around since opening up the game's class system and thus is tied with the most class levels on the team) takes the bench in her place.
The tl;dr is that DQVII was pretty stupid with its class system while FFV wasn't, even if it meant conferring everything invested in Galuf onto his granddaughter immediately after his death.
Also, what were you expecting? An angst montage? In a game where a turtle dukes it out with a sentient tree parading around in a suit of armor DBZ style? Well okay, there were a couple, but they still didn't dwell on them for long like in later FF games.