For some of us, playing StarCraft competitively is a beautiful ballet of dying over and over again, so it's good that Blizzard is working hard on making death interesting in StarCraft II.
The latest update to the Developer's Corner section of the official StarCraft II web page showcases this video, kicking off with a Protoss carrier dying before getting to the real meat - Zerg dying in droves. Whether they die by fire or simply explode in a shower of guts and pointy bits, there's nothing quite as satisfying as a horde of Zerg reduced to its component parts, unless of course those Zerg are you.
Oh hell, admit it. It's fun to watch them die even if it is you.
StarCraft II Unit Death Animations Update [Official Website]