I've always liked, but haven't had a chance to implement, the idea of giving the dead player a relatively short quest in the afterlife. Not necessarily an easy one though so it's not guaranteed they'll complete it. If they succeed then they're back, if they fail or "die"(as much as a spirit actually can) again then the character is gone.