If you find that so insensitive that you can't continue the conversation that's fine with me.
Having magical religious experiences on LSD is practically a meme, so I am not sure what would lead you to suggest otherwise.
There might be traces of cannabis in the hebrew Bible but it's not a common theme and pretty much every word this idea is usually based on could be a reference to something else.
There are religions using psychedelics, some of them probably quite old, but none of the big, popular ones do. In part this is explained by european (and similar) traditions surrounding government, which tends to be very suspicious of strong feelings and competition from drug use when it comes to the loyalty of their subjects, so for a religion to become a societal institution it has to get rid of the drugs if there are any.
Edit: As for modern interpretations of e.g. LSD as a religious experience says more about cultural poverty and millenia of ideological subjugation than the experience itself.
Dionysian festivals, although not proven (it's hard to find samples of ancient ritual wine), are strongly suspected to mixed something psychedelic (probably ergot) into wine as part of their ceremonies. Of course, that trance inducing wine was the blood of Dionysus. And how could it not be? You drink it and feel the essence of a god right after (the trip).
It is fairly firmly established that roman mystery religion shaped some of early christianity, in particular the Mithras mysteries.
What do you mean by "the Church would actively integrate local cultural iconography into the bible to make it's spread more palpable", can you give some examples of such iconography?
As for what drug experiences can tell us, I didn't claim they say anything about "the whole universe". They can however tell us other things. For one, LSD causes parts of the brain that usually work in a synchronised manner, like a system of cooperating parts, to loosen from each other, which is probably why one can experience a loss of coherence in perception of self and the immediate surroundings. At the very least it tells us that this molecule interacts with the biological foundation for experiencing the world as coherent, understandable, and when we're under its influence this experience is distorted or dissolved.
This tears into the feelings foundational to big religions, the perception of the universe as created, ordered, having a telos, can easily be temporarily disrupted, and hence we know that this 'wisdom' is contingent on us ignoring the possibility that it is a product of evolution rather than a divine gift or insight gained through spiritual exercise. You could of course project magical thinking onto such molecules and consider them demonic or whatever, but good luck keeping that up under capitalism without being victimised by conspiracy theory grifters, marketing specialists and so on.