Sometimes, even before I watched Sweet Rain, I thought of this question. My view is the Death itself is nothing interesting, the only thing interesting is the status you are about to die and duration you take to die and what will happen after death.
Status and duration before death, of course, we hope to have no burden when we are dying, and we hope it comes as soon as possible so that we won't suffer, but not many would have achieve this. However, I read across somewhere that when people get older, they getting more fear toward death. I wouldn't know about this as I am still young, and everything I say now would not affect my process of growing. Overall, I quite agree with this phenomena because it explains why all the dictators in the past ask for longevity when they grow older.
As for after death, there had been many version from various religion.
Christians said as long as you believe in Jesus, you can go to Heaven, to be in Jesus' side, otherwise, in common phrase, GO TO HELL.
Islam is almost the same as Christians, just that they are more extreme, they say one day is Muslim, always a Muslim. So no matter what you believe, as long you were Muslim regardless of duration, after you die, they just bring you to their Heaven, they are doing the same to your body as well.
Buddhist's version is more like a merit system, normally you will reincarnate as human, the status in society of the human you reincarnate will depend on your merit. When you gain the highest merit you can get in the ranking, you can go to Heaven in the west. However, if you get demerit, you will reincarnate as animal, that's why some Chinese swear others: "You are worse than animal(畜生都不如)" If you get demerit worse, you will go to hell, the hell also got 18 levels of punishment depending on how many you demerit.
I'm not sure about Hinduism, but I think they are talking about reincarnation as well, since Buddhism is evolved from Hinduism, just that some of the Hindu think that all parts of your body must die to be able to reincarnate.
To most Chinese, Taoist overlaps Buddhism, most of the time you see Chinese praying on a god's statue for wishes, that is actually Taoist, but most the time they will call themselves Buddhist. True Buddhist don't believe in god and never pray to god. However, Taoist view of death is also reincarnation, but they say there is some transition period before you reincarnate after you die when you exist as souls. During this period, your soul is vulnerable, you may get unexisted(魂飞魄散) if your soul get damaged. And some souls who either cannot reincarnate or refuse to reincarnate will exist as third dimension being in Earth.
For me, I don't like the idea of exist forever after death. It will be painful and boring after you attempt everything in this world, not to mention after you finish doing all the good deeds then you attempt the evil deeds, and eventually nothing seems to be interesting anymore. If can, I wish to be unexisted after I die. Reincarnation still sounds good because all my memory will be erased as memory is what build up our souls.
What kind of life you want after you die?