One is not asleep or in coma during a psychedelic drug experience. What goes on around you determines the nature of your experience, as does your own preparation, intent, how you manage the effects, your state of mind at the time, and so on.
There are therapeutic effects of psychedelics; e.g., treating depression, post-traumatic stress disorder, addictions (alcohol, tobacco, opiates). Explanatory models gets slippery, though. Some believe that "spiritual" experiences brought on by psychedelics are curative, whereas less theological models posit a enhancement of mainstream therapeutic processes, such as increased contact with emotions.
More slippery are claims that psychedelics "enhance spiritual growth," like meditation practice; or somehow make people "more spiritual." I know of a Jewish congregation that uses DMT-containing ayahuasca during Shabbat services on Friday evenings to increase their concentration, visualization, emotional involvement of their davening.
What is suspicious about my contributing to this thread? I'm neither supporting nor rebuking OP. I'm trying to enlarge the discussion because I've studied it for so long, performed hands-on clinical research with these drugs, and worked hard to understand how psychedelics may contribute to explicating the metaphysics of prophecy.