I feared death when I was a kid. I am now a 20-something and no longer fear dying. It is the pain associated with most forms of death that I'd rather avoid. I'm not eager to find out what comes next, I'm too busy trying to see what all this life has to offer. When my time does come though, I hope those quick forms of death really are painless. If I get the, 'die of old age' option though, I hope that is painless too.
As for the afterlife...I'm hoping it goes by Discworld rules. Whatever you believe will happen is what happens. Heaven, Hell, reincarnation, judgement, Valhalla. Anything is possible. It's the probability that is the problem...Either way, we'll all find out some day.