I'd be careful, a friend of mine answered yes (and doesn't smoke anymore/at the time of the question) and got denied a clearance for it. But we can also see others who are suggesting interviewers are pressuring them into a "no" answer, which I had some personal experience with. But it seems different people are having different experiences. I understand why people lie though.
I always found this odd too because I agree with the sentiment that you're expressing. It's always been told to me that the reason they don't want people with a history of drug usage (different from current usage) is that it can be used as blackmail against them. But the explanation of blackmail is that it can get them fired, from a job where the only reason that happens is because you lied on your clearance. Wouldn't they want no skeletons in the closet?