Prohibition doesn't work because people want to modulate their consciousness, chemically force-relax, reduce inhibitions, etc. It didn't work before, and it won't in the future. The more things are forbidden, the more taboo and attractive they become.
This banal, smiling, petty authoritarianism sickens me. Bodily autonomy trumps "common good" arguments, and where it somehow doesn't, injustice abides. Society's job isn't to crush individualism in order to create the safest and most financially efficient outcome. Shall we throw everyone in prison for their safety and protection next, and control their diet to ensure maximum healthspan and potential for participation in the labor market?
Rather than banning anything, point out at an early age that cigarettes stink, get you addicted, cost money forever, and cause health problems. Point out that alcohol makes you fat and causes heart problems and cancer. The accept that each person has the right to make a decision for themselves about what risks they're willing to accept to achieve a desired outcome, and that they have to own those consequences.
Don't want to pay for smokers' lung cancer treatment? Then only fund palliative care for smoking-related cancers. Man enough to smoke a pack a day, man enough to buy smokers' insurance. There, now we can live free.