It has been proven to significantly reduce depression and anxiety in cancer patients [1]. This has been one of the most famous studies on psychedelics in recent years. However, set (patient's mindset, intentions, psychological preparation) and setting (environment, support of the sitter) have huge impact on the outcome. That's because psychedelics are not a switch that change your brain chemistry forever, they are a tool that allow you to enter, understand and reshuffle your mind.
[1] https://journals.sagepub.com/doi/10.1177/0269881116675513