In about 8 trips over as many years, I haven't had a bad experience, except one that just went on too long and became exhausting.
Yet I have had friends that are far more psychologically stable react negatively to it.
I've never seen anyone react badly to MDMA, and I think it may actually be more useful for emotional work. LSD makes me generically happy, but I'm more likely to develop a fascination with areal mapping than gaining any introspective.
Marijuana is pure hell. Sleepless nights of mild nausea, intense headaches, and terror nightmares. And mixing it with alcohol drops my blood pressure to syncope/sweating/panic levels.