So are there any advantages in a heroic death? Or does it just not matter?

Not unless you consider the sweet relief of permenant death to be an advantage