I've always loved the Guardian/Final Guard death animation in SotN. Those are the guys in the inverted castle, on either side of the central clock room in the Marble Gallery. When you kill them, they kneel down and disintegrate into dust, which slowly floats upward as some particles catch the light. Really a beautiful animation.