I've heard that DMT will scare the hell out of you. From what I heard, it is like a 5x to 10x intense trip, compared to LSD, but that it doesn't last nearly as long. I've done shrooms, lsd, and ecstasy. My advice is to stay away from all of the above.
I've had good experiences (extremely good in some cases) and bad experiences. I've had experiences that started out one way and then went the other way. LSD can make you feel like you're in heaven. It's like you step into a brand new world, and suddenly all of the drab surroundings and objects you've known your whole life become fascinating. They are suddenly brand new, and at the same time, you gain a new perspective and feel like a philosopher. You feel like the secret to the universe is just one tiny step removed from you, and you think if you just do some more acid trips, you'll find it out.
It can also cause you to have terrifying experiences, and when that happens, you are stuck with it. Depending on the dose you take and what kind of dose it is, you take a dose and whatever happens to you is going to happen over a period of 8 or 12 hours, maybe more than that. If you decide you hate this feeling, too bad. Then there is the fact that if you get caught, you are facing potential massive prison time. In the U.S., under the law, a container for an illegal substance counts as an illegal substance itself. What this means is that if you buy a 200 micrograms dose of lsd that is delivered via a piece of gummy candy (lsd is sold like this. Gummy candies, sugar cubes, etc. in addition to blotter paper. Check me on how much one dose is. I'm going off memory.), the entire gummy candy is considered LSD. Some dealers sell bags of gummy candies that have lsd absorbed in each piece. If you get caught with an lsd dosed gummy candy or (god help you) a bag of gummies, you can literally be imprisoned for life, because of this rule about containers. LSD weighs nothing. One dose is a tiny tiny fraction of a gram. This means that your bag of a handful of gummies can be considered the equivalent of dozens, hundreds, or even thousands of doses.
The next bummer is that LSD is well known to cause permanent brain damage. So is ecstasy, and almost certainly shrooms do the same. As you have already noted, they can cause you to have recurring psychoses that won't go away without medication that you will have to take for your entire life. LSD can cause panic attacks and severe depression. If you already have depression, it is almost guaranteed to make it worse. There is a new thing with micro dosing that is thought to potentially help with depression, but idk much about that. What I do know is that if you do it the old fashioned way, and take 1 or 2 or 5 or 10 blotters or gel tabs, it's going to f up your mind if you have any preexisting problems. I've saw plenty of this and experienced it myself.
It's fraught with risks and the payoff isn't close to worth it. Those genius level philosophical insights you have, the next day when you think about them, they're dumb as shit. I've heard that this wormwood oil that people trip on can cause you to have genuine insights that are very useful, but this is not the case for me or the people I've known with lsd. I remember one time I thought I'd had an amazing insight over a thought process about "if I were a fish, would I get caught." I had reasoned that I would, because when I go to the restaurant and get a hamburger, I don't check to see if there's a hook in it. This is the kind of nonsense you will think.
I'll also try to give some of the good side. IMO there is really no good side, for practical purposes, because I've seen what happens to people long term, but there are people who seem to benefit. This is mostly people who are terminally ill. There is evidence, although mostly anecdotal, that terminally ill people can come to terms with their fate through lsd and other hallucinogens. They can do so in a way that is therapeutic and that their loved ones can recognize. Then, as I mentioned before, micro dosing seems to have some amount of evidence for efficacy. I wouldn't think of trying micro dosing myself, but I can't knock anything for someone else if it really helps. It's also good for people who have severe headaches. There are certain varieties of headaches that are abnormally intense and that are extremely resistant to typical therapies. It has something to do with brain chemistry, and lsd just happens to completely get rid of them if and when they occur.
Last thing I will say is if you have a family history of mental illness, these drugs are a definite no.