SE=search engine.
Traditionally Tibetans in Tibet have used Datura seeds and Wormwood for the big public Dharma transmissions, to get people in the mood.
I find both these herbs very satisfying as incenses.
Of course, Datura smoke is not only used as a psychoactive, but as an effective anti-asthmatic.
Syrian rue is a traditional Persian incense, used at weddings to get the nuptials in the mood.
In Japanese Zen temples Patchouli is a standard ingredient to calm the body/mind for sitting meditation.
The Arabs use Agarwood as a psychoactive incense, I find it excellent to induce sleep.
There's so much more, only scratching the surface, but for those interested check out Olfactory Rescue Service.