As far as “expanding horizons”, psychoactive drugs in a carefully dosed and controlled environment can give creative people new ideas and understanding. I have known many people during in my career who developed revolutionary ideas based on new psychedelic perceptions. More advancements in math, engineering and computing have been sparked by psychedelics than we may ever know.
Does God, the Creator, want us to use them? I think He does if used responsibly and with intentions that follow God's word. Why else would He have placed these tools on every corner of the Earth?
Just like He placed iron for us everywhere that can be used for good AND evil. It is not the object, but rather the user and the intent. Arbitrarily outlawing tools He left for us and not even studying them is extremely ignorant IMO.
The bible warns against the use of intoxicants and mind-altering drugs.
I have never met anyone who was helped by drugs. As an assistant chaplain on the drug/alcohol detox unit of a veteran’s hospital, I can attest that they were living shells of a life. Any insightful ideas they had were gobbled up in what we called “fried” brains.