Mine is the defence of Hearthglen in RoC. It perfectly encapsulates the feeling of hopeless dread when the hordes of undead march upon a peaceful Lordaeron Summer town. I wonder if they are going to change it.
The Under the Burning Sky, Undead finale, is peculiar, too.
TFT has a lot of great moments (better than RoC), but the second mission of The Curse of the Blood Elves is just shocking when the outer bases are being lost. The Outland chapters are flavourful, too.
The Undead campaign is just crazy though. The first mission and the past in particular.
Gameplay wise this mission is a direct salute to StarCraft: Brood War’s True Colors, where the player is originally up against two disproportionately larger forces but is given a few minutes to attack one of them with impunity. The quality of said attack’s execution also dynamically impacts the difficulty of the entire mission.
Story wise it was a testimony of Sylvanas’ abilities to conduct lateral thinking and manipulate everyone into behaving exactly as she wants them to. It is with these that she has been able to achieve what she has in WoW’s Cataclysm and Battle For Azeroth expansions, where the Forsaken and the Horde saw tremendous gain of territories against the Alliance under her leadership.
The missions involving her in TFT is a miniature version of her later character development in WoW, where she started out just fighting for vengeance (like she was in Wrath of the Lich King) and progressively became power-hungry and morally ambiguous but at least living with a real purpose (like she’s been since Cataclysm)