Sam Harris recently interviewed historian Brian Muraresku about just this topic. Brian studies ancient mystery religions, in which a central part of the “faith” was often an experience that was likely induced by psychedelics. It’s frustrating how little first-hand literary evidence there is, but archaeologists have managed to find actual ancient wine jars laced with all sorts of interesting crap — wine back then wasn’t the pure stuff we have today.