One of my players; Gabriel (age 11), had a character; the knight Xandras, who sacrificed himself to kill a dragon.
Xandras died, and his soul went to heaven and became a star, in the firmament right over the spot where the battle with the dragon took place. This is what happens to the souls of heroes and heroines in the word of Fabula (my frpg game)
It happened some weeks ago. We play once a week.
In the session this week another player mentioned "The Star of Xandras", and I looked at Gabriel just then; he beamed! His face shone with pride over his former character; the knight Xandras, and what he had done; his sacrifice. It was beautiful!
We try to play death as a significant and holy thing in my game. To see Gabriel shine with pride, confirms for me how meaningful such a praxis are. Burial, eulogies, and reminiscence gives something extra to the death of a character. They are important facets of the life a character live in the mind of the player.
Do you have positive experiences with death in role-playing games?