My campaigns have sex, drugs and violence, but usually neither is graphic, with violence coming the closest thanks to detailed descriptions in some cases.
Sex is, with a cleric of a love/lust goddess as party leader, an important part of the campaign, but stays with seduction/flirting as far as details go.
Drugs are around, and are used by NPCs mostly. The party encountered an opium addict lately, as an example, thrown in as a red herring (they observed the opium deals, thinking it was the traitor they were hunting).
Sex is, with a cleric of a love/lust goddess as party leader, an important part of the campaign, but stays with seduction/flirting as far as details go.
Drugs are around, and are used by NPCs mostly. The party encountered an opium addict lately, as an example, thrown in as a red herring (they observed the opium deals, thinking it was the traitor they were hunting).