I have no qualms with dying. Its a natural part of our existence. I'm sure that if I had any children or a wife, though, I'd want to be a part of their lives for as long as they could stand me.
A large part of me thinks there's no afterlife, and agrees with the views in Ecclesiastes. But there's a part of me that hopes that within many of us is the spark of the divine, and that on death, it'll manage to attain or re-attain its intended state.