Personally, I await death eagerly. Don't get me wrong here, I don't believe in God in any form, and I'm certainly not arrogant enough to feel I would get into Heaven if it did exist after. I am a very scientific person, but I have a profound desire for the reality of the supernatural. Bit of a mix really.
At least, that's what you may think. In fact, I believe in the pure power of the human mind. Placebo medicine is proven effective in many cases, and the field of psychology is very interesting and developing at an incredible rate. Thousands of years ago people's unadulterated belief in Jesus' divinity has etched him into our minds and societies forever. For me, it is clear that the countless phenomena witnessed by countless people globally every year are products of their own minds. I do not, however, think that makes them any less real.
This is where I start getting on to death, but first, a little about sleep. When we sleep we dream. No arguing; we dream, but sometimes we just dont remember. Dream memory works in a similar way to real memory, in that unusual events are more likely to be remembered than those that are commonplace, thus a dream about a huge green blob-monster is more likely to remain in our minds when we wake than a dream about walking down the road. This is why we "dream less" as we grow older, our imaginations become less active, so our dreams become more "normal" and thus fewer are remembered. Thus the technique of lucid dreaming was born, where a person falls asleep with the intention to dream, and stays conscious throughout. This is obviously a greatly contracted description of the technique, and I can assure you it is not as easy as it seems. Skilled lucid dreamers are capable of making an hours sleep last countless days in "dream-time".
I believe that the brain, when starved of oxygen, starts to direct our consciousness into a lucid dream-state. This explains our fainting when we asphyxiate, and also why we apparently see the tunnel of light, just before we die. In this way, at the moment of death, we can spend the rest of eternity in a paradise of our minds' own construction, condensed in that infinitesimal instant before brain-death. I feel it quite neatly ties up the end of life; something to look forward to, without the need for a belief in a higher being of any kind.