Nope, that's typically a deal breaker. It's the stuff they find out that you didn't want them to know that can get you blocked. The thinking is that if an adversary finds it out, they could use it as leverage against you. I've held clearances in the past and was forthcoming about marijuana use. It largely comes down to the judgement of the investigator. I'm really not surprised that some people have been bounced for drug use and some people haven't.