To suggest that the Bible was written by people who used psychoactive substances betrays a serious ignorance about the body of texts and their history. It's simply a ridiculous statement! Notions like that shouldn't be taken seriously at all.
The Bible has a growing wealth of historical and archaeological records, and a myriad of testimonies, so to suggest things like mass hallucination is not only anti-scientific but illogical and a blatant disregard for history.
This is actually the Bible's strength — it records for us events that didn't merely occur in a person's heart or mind, but objectively in the open for everyone to see. Peter puts this very plainly in 2 Peter 1:16 when he says: "For we did not follow cleverly devised myths when we made known to you the power and coming of our Lord Jesus Christ, but we were eyewitnesses of his majesty."
And Paul says the same in Acts 26:26, where he explains that the work of God didn't happen out of sight, but publically: "For the king knows about these things, and to him I speak boldly. For I am persuaded that none of these things has escaped his notice, for this has not been done in a corner."
Or we can think of Luke, who diligently recorded the history, saying in Luke 1:1-4: "Inasmuch as many have undertaken to compile a narrative of the things that have been accomplished among us, just as those who from the beginning were eyewitnesses and ministers of the word have delivered them to us, it seemed good to me also, having followed all things closely for some time past, to write an orderly account for you, most excellent Theophilus, that you may have certainty concerning the things you have been taught."
In a word, we could only entertain the idea of the Bible being a result of psychoactive substances providing it was written by one person and without any historical records, but that's not the case. God works in history, through many people, and in many ages. He walked and talked among us in the person of Jesus Christ, and He bled and died for our sins, and was raised for us, that we may be raised with Him.