BS”D:
It really depends on the situation. In most cases (B”H), the person is old and sick beforehand, and they are really in a better situation for themselves (like Amasa D’Rebbe who davened that Hashem should take his neshama) in the Olam HaEmes. There are many gemorahs regarding Nechumim, you may want to take a look.