From what I understand they do help with the anxiety of end of life care.
What I think happens is that you take mushrooms/LSD for the first time in that condition and then you fully realize the size and scope of yourself and the universe, and get the giggles, and everything's a little easier to take.