I tend to assume that if there's an afterlife, it will be a positive one or at least one with hope. The Buddhist concept of rebirth makes the most sense to me, but of course I know that I might be wrong. So I don't fret death because if there isn't an afterlife, I will not exist; if there is one, it will probably be at least as interesting as this life.
The idea of being tied to a corpse while it rots, though, and fading into nothing slowly rather than abruptly, is horrifying. Of course, no one believes that this actually occurs; people are generally divided between those who believe that consciousness leaves the brain at death and those who believe that it ends at death.
Oddly enough, this delusion explains something I've always found unusual about ancient religions. People often say that religions were founded to assuage existential fears. That doesn't make much sense, though, because many ancient religions had negative afterlives. The Babylonians believed in an afterlife, but it was a repulsive one. The ancient Greeks believed in the gloomy Hades (although they later introduced the Elysian Fields and the possibility of reincarnation). The Egyptians believed that a life of drudgery in service to the pharaoh would continue into the next existence. Hells seem to have evolved in religion before heavens, which came into mainstream religious thought around 1000 BC. Religions were founded to explain away uncertainty in general, and not specifically to assuage existential guilt because most ancient religions had gods that were total assholes (if you're using gods to explain smallpox and earthquakes and war, it makes sense) and afterlives that were undesirable.
It brings up an interesting question, though, which is why would anyone choose to believe in a negative afterlife as opposed to none at all? The Cotard delusion may explain it. Perhaps this horrible state of consciousness (which seems to be a subtype of severe, psychotic depression) was more common in a coarser time, and led people to the belief that to be dead was not nothingness, and not some desirable or blissful spiritual state, but one of constant and featureless despair.