Sure it can. If we are strong enough,fine. Besides, the biggest danger isn't in the presence of the Divine. The unconscious mind will happily produce all sorts of fantasies if you ask. It isn't a case of how effective the participants are, rather, how ineffective.
Delusion is a stock in trade for the occult arts.
Here you seem to have come around to my side. Most dangers come not from the presence of the Gods, but rather from their absence. In a not uncommon example, priesthood who begin to expect, to demand, the reverence shown them when they are vessels of the Divine be shown them when they are not exercising their theurgic office. And they may be as solicitous of humans as a human is when caring for a small and fragile animal, but They also do not exercise the same controls on humans that humans do on animals, and rarely force us to turn away from danger, though They try and protect us when we think to ask for it. My own experience has included more than a little emotional discomfort, but almost all of it was in those periods when I wasn't receiving palpable confirmation that the work was acomplishing anything.