Sacred Haven of Debauchery

Can you recommend a game in the mysticism genre with psychedelic elements?

Try Masquerade, although it's not particularly psychedelic. But since you liked that Simpsons episode, check out other works by Poe.