While I cannot claim to represent official Church policy, the following things seem to me to be the consensus of view of the CoS:
1) Yes, responsible alcohol use is "condoned" at the discretion of the user. While I myself generally oppose intentional intoxication from alcohol, I also drink regularly in moderation. That is to say, I drink often, and never get drunk. No more than a couple drinks at a time. Use your judgement.
2) Tobacco use does not readily cloud one's mentality, and while it can be argued that it shortens lifespan, so does a lot of things. If you choose to indulge, do so at your own risk. Just don't complain about the potential results. Responsibility to the responsible.
3) The Church of Satan
clearly opposes the use of illegal substances in any quantity. If marijuana is illegal where you live, then it is not considered acceptable to use it. If it happens to be legal where you live...again, use your judgement. Why are you seeking intoxication in the first place?
The difference is one of indulgence and compulsion. Alcoholics are compulsive. Light drinkers usually are not. Intoxication is usually a compulsive act of self-escape.
Rather than ask "what would the CoS do?", ask, "why would I wish to use substances for the express purpose of decreasing my mentality?"