I can see some sort of rules for a great death provided that they are not cheapened by a simple cure of revivify. You die and cannot come back, but you should be able to do something cool on your way out. "Tell them, my death was awesome."
I might allow a PC that chooses a dramatic death a chance to use a full action on their turn. Maybe they Hodor allowing the rest to survive, or diving into the flooding submarine hold to pull the lever. Something cool, but you do not come back.
View attachment 274657