My response is entirely anecdotal from personal experiences and friends. They are not based on any scientific research.
I've tried both LSD and shrooms. They've been my favorite since they aren't about feeling high. It's not about elevating your mood like marijuana, cocaine, extracy. They aren't about making you chill like alcohol, benzos, and opioids. The best way I can describe it is that it feels like you have more conscious access to your brain. It's like a lot of the filters that control your perception are removed or altered. While most people focus on the hallucinations, I think the important part is the access to your mind. Another bonus is that since they aren't about getting that emotional high, they're not addictive.
On each occasion, I've left the trip with a new outlook on life. It's like I have all these things that are hidden from my consciousness, and bringing them into awareness helps me address them. I have a friend that live sin the mountains and drops shrooms regularly every 3-4 months as a reset. It helps him readjust his priorities and get back to his life's purpose.
I've heard accounts where things went bad, but I haven't had that experience. If you're with a trained professional, you might be in good hands. There are videos online of reputable people going to South America and trying ayahuasca, so that might be something you'd be interested in watching.
If you try it out, please report back and let us know how it went!