I have seen a few people dying and most of them had a kind of resignation about the fact, or a religious perspective about it. There has only been one person dying who kind of disturbed me - he was a distant relative of mine who had been a German officer in WWII. I suspect that he had probably done a lot of things he was uncomfortable with (deep down discomfort). It seemed as though all these things came back to bite him in the backside in his last few days. I don't want to die like him.
* I hope that no one mourns me. *
Personally, I anticipate my own death with some unease - I am both spiritual and religious (that distinction was made by someone else on another thread) - and my religion doesn't hold death forward as anything good or appealing, but rather as a change. My own feeling is that death spells the end of whatever we have been trying to do in life, which at some points in my life has seemed appealing and at other times worrying. If I were to die tomorrow, I would feel that I have a lot of loose ends I wish I could tie up.