I think that's a fine analogy, actually. The writers seemed aware of it, too. For example, in Accession the "orb shadow" sounds very much like an hallucinogen flashback.
However, the references in DS9 to faith generally sound very much like they are intended to be taken as metaphors for Christian faith.
Well, to be fair it's not as though people haven't used mind-altering substances to have a Christian faith-experience before.
True. Point taken. I bet there are quite a few people who have dropped acid and found Jesus.
It's just that psychedelic mushrooms aren't served with the bread and wine, at least at most Eucharists.