No smoking on long flights is a result of customer demand, not airline nepotism. That is why some airlines still allow it (mainly Asian).
Personally, I wouldn't fly with a smoking airline- you can never get away from the stink.
Alcohol is similar- anyone who can't do without alcohol for 8 hours has a serious medical or psychological problem.
If you want to get tough on air rage, you have to eliminate alcohol from the equation. As long as it is served, the problems will persist.