Fundamentally, it is a philosophically unsound extrapolation and pastiche of normal earth religious afterlife myths mapped onto a system that allows for fairly trivial rezzing. The morality of death, when subjected to rigorous philosophical analysis, does not make for particularly good drama or narrative arcs. Determine the philosophy of your universe to suit your character goals.

Quoth:

Cosmology and the Afterlife:

Greyhawk uses the classic "Great Wheel" cosmology as defined in the Manual of the Planes and the Planescape setting. After death, the souls of the dead travel to the plane of their deity and become petitioners. The souls of those who die believing in no deity vanish from existence, although it is rumored that a dark power is secretly harvesting these souls for some awful purpose.

Therefore, souls become petitioners after death:

Upon its death, a mortal creature that served a deity faithfully will reform on the home plane of that deity. If the new petitioner continues to serve its deity, it can be made even more powerful. Most petitioners, however, are content to simply live out their eternity in whatever form their god has chosen for them.

In Planescape a petitioner loses all knowledge of their previous life. They are also unable to advance beyond the zeroth or first level of experience.

In Dungeons & Dragons 3rd edition (also referred to as 3.0) and 3.5 edition, Petitioner is a template from the Deities and Demigods book. The template uses the base stats of a creature and remakes it so that it has 2 HD and nothing more. A deity can have an unlimited number of such templates servants.

Note, however that this rather undermines the punishment-fantasy role of the afterlife, as Frank and K note:

In D&D, creatures do not "fall" into Evil. Being Evil is a valid choice that is fully supported by half the gods just as Good is. Those who follow the tenets of Evil throughout their lives are judged by Evil Gods when they die, and can gain rewards at least as enticing as those offered to those who follow the path of Good (who, after all, are judged by Good Gods after they die). So when sahuagin run around on land snatching children to use as slaves or sacrifices to Baatorians, they aren't putting their soul in danger. They are actually keeping their soul safe. Once you step down the path of villainy, you get a better deal in the afterlife by being more evil.

The only people who get screwed in the D&D afterlife are traitors and failures. A traitor gets a bad deal in the afterlife because whichever side of the fence they ended up on is going to remember their deeds on the other side of the fence. A failure gets a bad deal because they end up judged by gods who wanted them to succeed. As such, it is really hard to get people to change alignment in D&D. Unless you can otherwise assure that someone will die as a failure to their alignment, there's absolutely no incentive you could possibly give them that would entice them to betray it.

You are essentially struggling with the morality of death in D&D. There is no "one" answer. I urge you to choose what flavour of morality and law you want in your world from this excellent discussion, as that will inform whether or not assassinating a chaotic evil overlord is a good act.

Also, if considering the implications of death and souls, this quote from HP:MoR is quite relevant:

"All right," Harry said, trying to keep his voice calm, "I'll hear out your evidence, because that's what a scientist does. But first, Headmaster, let me tell you a little story." Harry's voice was trembling. "You know, when I got here, when I got off the train from King's Cross, I don't mean yesterday but back in September, when I got off the train then, Headmaster, I'd never seen a ghost. I wasn't expecting ghosts. So when I saw them, Headmaster, I did something really dumb. I jumped to conclusions. I, I thought there was an afterlife, I thought no one had ever really died, I thought that everyone the human species had ever lost was really fine after all, I thought that wizards could talk to people who'd passed on, that it just took the right spell to summon them, that wizards could do that, I thought I could meet my parents who died for me, and tell them that I'd heard about their sacrifice and that I'd begun to call them my mother and father -"

...

"And then," spat Harry, the fury coming fully into his voice, the cold rage at the universe for being like that and at himself for being so stupid, "I asked Hermione and she said that they were just afterimages, burned into the stone of the castle by the death of a wizard, like the silhouettes left on the walls of Hiroshima. And I should have known! I should have known without even having to ask! I shouldn't have believed it even for all of thirty seconds! Because if people had souls there wouldn't be any such thing as brain damage, if your soul could go on speaking after your whole brain was gone, how could damage to the left cerebral hemisphere take away your ability to talk? And Professor McGonagall, when she told me about how my parents had died, she didn't act like they'd just gone away on a long trip to another country, like they'd emigrated to Australia back in the days of sailing ships, which is the way people would act if they actually knew that death was just going somewhere else, if they had hard evidence for an afterlife, instead of making stuff up to console themselves, it would change everything, it wouldn't matter that everyone had lost someone in the war, it would be a little sad but not horrible! And I'd already seen that people in the wizarding world didn't act like that! So I should have known better! And that was when I knew that my parents were really dead and gone forever and ever, that there wasn't anything left of them, that I'd never get a chance to meet them and, and, and the other children thought I was crying because I was scared of ghosts -"

If you're actually struggling with whether destroying the mortal shell of an immortal soul is immoral, considering the implications of how people should act with the fundamental knowledge of souls and their existence is a fun philosophical problem. On the other hand, I doubt that your DM really wants to consider how peoples' behaviour changes when they understand and can prove an entity separate from the meatbag exists, as the triviality of resurrection and the implications of animating grandfather to have another farmhand are... not particularly interesting to most groups.

At the end of the day, I would choose whichever options give you an interesting moral question without making your choices either trivial ("Meatbags? Who cares?") or stupid ("Wow, I know my soul will be devoured if I do this. I can watch this process in action. Maybe I shouldn't do this.")

Most of the rest of the World of Darkness creatures are in some respects or other human beings, and the deaths of humans, as described in Wraith: the Oblivion, leads to nonexistence, either through transcendence or oblivion. Those who have reasons or will enough to keep existing after that may become wraiths — see the aforementioned WtO — or otherwise remain as denizens of the Shadowlands.

Mages die as people do, although their Avatar shards return to the cycle and become attached to new humans with the possibility of awakening.

When it comes to changelings, the Sluagh book puts forward a theory that the Faerie soul reincarnates through the Changeling Way, reforming time after time in different kiths until, finally, one ends up as a sluagh in one's last lifetime. This is thought to be the result of unreliable narration, as it's not backed up in other books.