Indeed; the Oracles at Delphi were revered for their ability to divine wisdom from auditory hallucinations which were literally equated with gods. In some modern western cultures, by contrast, you even have active gaslighting of those who are vulnerable to such conditions and exacerbation of their negative qualities.
I would be careful equating the oracles of Delphi with psychosis, since religious practices can bring about visions and out of body experiences without drugs or underlying pathologies. For example, some Eurasian shamans practice "ecstatic dance" where oxygen deprivation and exhaustion result in shamanistic experiences (visions, auditory hallucinations, etc) without the use of drugs.