Depends. I imagine the opportunity cost of alcohol and cannabis outweigh their benefits from lost productivity. So likely those industries merely give an illusion of positive economics

The economic windows are less broken when people smoke themselves stupid than they are when we send state violence after those people. This goes for most "bad" things. (State) violence is just that destructive to productivity. See also: prohibition.