Or perhaps it can open doors that will end up holding you back. There are people who are legitimate acid casualties. I know a guy who now has social anxiety so bad that he rarely leaves his house. This was most certainly not the case before he indulged in copious amounts of LSD and Psilocybin.
Weed will much easily make you paranoid in my opinion.
But in fact, too much introspection can go wrong and plant ideas that don't make you go forward.
There is a saying of a guru: "If something goes bad, just drop some more acid" but I am not sure if it is a good advice, only that it doesn't work with weed.
Anyone that is not a doctor or pharmacist who says anything along the gist of "If you aren't doing X while taking drug Y, then you need more of drug Y" is an idiot. Everyone is different, dosages will be different, and interactions, chemically with other drugs and psychologically with other issues, will always be present.
I'm all for anyone doing whatever they want with drugs, psychoactives in particular, but taking more is usually the wrong answer. Psychoactive drugs are not a cure-all or magic key that opens creative inspiration in uncreative types, just as much as taking Vicodin won't give you an erection lasting for more than 4 hours.
Good psychotherapy can heal him. I suggest "Changing Personal History" or more powerful (but harder to learn) "Core Transformation" from NLP.
P.S. There is a huge amount of inefficient and even dangerous psychotherapy schools, and there is quite a lot of inefficient stuff in "NLP", that's why I recommend exactly the above techniques.