There is indeed a very thin line between psychosis and intense religious experiences. It is why in some religions, knowing God will literally burn the mind.

I would recommend psychedelics, but like anything, it depends on the person. There are dangers, but those dangers can be controlled quite well. At the population level, it is safer than coffee. At the individual level, it varies, just like anything else.

I will note that after taking ~110 μg of LSD-25 on several occasions, my overall cognition improved dramatically.