It definitely is for those things, but in general it’s meant to encompass things that would cause problems if a coworker or manager looked over your shoulder. Graphic depictions of illegal drug use is borderline which is why I wanted to ask the community how they felt about it.
The original question came up over snorting drugs through a rolled up C note but would also likely encompass shooting heroin or smoking meth/crack. But the consensus appears to be not to ask for an NSFW tag at this time. So that will be our stance unless you guys decide things are going too far and you want the tag included on posts with that sort of content.