Certain poor formulations of church incense can induce a mild euphoria… however, the only person getting enough incense concentrated enough to experience it is the server tending the censor.
Sufficient quantities of carbon dioxide and carbon monoxide can induce a euphoric state as well. Again, no risk in the pews at all.
The biggest risk in the pews is the use of resinous compounds to which someone is allergic.
Me, I have to take allergy meds if the incense includes solidified rose oil. A friend of mine is allergic to Myrrh.
Technically, Incense may be used for any Roman Mass. Priest’s choice. Many don’t, because quality incense is expensive; A box holding 500g (just over a pound) is often from $30 to $50. Pure resin incense is the best, and mixtures of Frankincense and Myrrh are the most traditional. Many more don’t because parishioners threaten to leave if they do so regularly. And many more have such budget constraints that they use it sparsely, for major feasts, or even just some of: the Nativity, Good Friday, Easter Sunday, and Pentecost.
Many of the Eastern Churches in Union with Rome require incense in their particular law and/or liturgical rubrics for all liturgies.
If you want more incense used, ask your pastor why he doesn’t use it. If he says “expense,” offer to provide it, and then get a GOOD resin incense. Or two.
One that a local Roman parish used during Advent included pine resin… I hated it, but the parishioners loved it. And kept telling the padre so. But one mass on sunday was designated “incense free”…