It more or so can lower your “defenses” in a mental kind of way but a lot of it is chemicals in the brain. You can use it to try and have a spiritual experience but when on drugs the encounters require a larger grain of salt due to the chemicals in the brain reaction to the drug.
I think just working on the senses is a much better idea then relying on drugs for a “possible” Spiritual experience that will most likely just be a chemical cause then spiritual.
there are some descriptions of Succubi appearing in what looks like a lamia form, or with their legs entangled, almost dragged behind them.
But a Succubus/Lilitu can appear in almost any form they want.
I’ve seen a similar form in a lucid dream/sleep paralysis dream.