As an addendum: I talked to my therapist about spiritual psychosis, because I've had visions, and I have a therapist, and she had some thoughts.
If you are noodling over what kinds of spiritual experiences are psychologically healthy and not, Abraham Maslow wrote a book called _Religions, Values, and Peak Experiences_ that you should probably read.
Psychosis comes with compulsions. If you have an experience and still feel free to choose for yourself what you do and do not do, religiously speaking, it's not spiritual psychosis. Spiritual psychosis is psychosis with spiritual window dressing. It is spiritually themed, but not actually spiritual in nature, if that makes any sense. If your visions are threatening, and you feel like you can't say no to them, that is spiritual psychosis. If Hekate appears and tells you everything is going to be ok, but you should probably work on being nicer to people (and you think about that, and tell her maybe, but that's really hard, and you don't know if you can do that) that isn't.
Another problem, also with spiritual window dressing, but far more common, is spiritual bypassing. This is when you use spiritual ideas and practices to sidestep or avoid facing unresolved emotional issues, psychological wounds, and unfinished developmental tasks. So, if you take a theological position that the gods hate everyone who does X because it triggers your trauma, that is spiritual by-passing. If the gods comfort you when you are hurting, that is not.
Edit: If you want to know what causes psychosis, here is an article. Funky religious and spiritual practices aren't on the list.
Vepar themed Lockscreens