My favorite death sequence for Dracula is from Portrait of Ruin. The sun entering from the window, the vanishing of the Count, and the music are perfect for me. The SCIV version is similar, with a cool ultimate transformation in bats, with the last one being consumed by the light. But I prefer the PoR version
.
As for the Castle destruction, I love the PSX Chronicles version, too. That details of the Castle were simply amazing for me the first time that I saw.
As an extra, did another Castle Destruction Sequence includes a running to the castle door, like in Lament of Innocence? I always asked after finishing a game, how is that the hero could survive a destruction with limited time to escape.
So, the combination of the three mentioned games (PoR-CVC-LoI) in one Dracula´s Death/Castle Destruction Sequence, makes the perfect ending for a Castlevania game
.