I know my experience is hardly unique, but death stopped being scary a long time ago. Not that I'm a brave man, quite the opposite, in fact. The pain associated with dying scares me a lot.
But being dead doesn't seem scary at all. A heart can only handle so much pain and self-loathing before...