Two come to mind:
Even upon revisiting, Doctor Who's The Doctor's Wife. Specifically, the end, where Sexy gets to say Hello to the Doctor. As someone who grew up with Tom Baker, Niel Gaiman and Matt Smith both did marvelous jobs making sucj a silly concept become extremely touching to a very long time fan of this franchise.
Not anymore, but as a child, Dinobot's death in Transformers Beast Wars. Like most kids my age Dinobot was cool to me cause he was edgey. Then to watch him beat up all the Predicons with a rock and a stick, all along the way knowing it was killing him, to save a race he didn't care about. And then used his last bit of energy to fuck Megatron's plans in the ass. And then it actually did kill him, no kids cartoon last minute reversal of the fauxed drama, one of my favorite characters, completely caught little Polyboros off guard.