taxing sin being a cop out that leaves all the harm of privatisation, all the harm of regressive taxation and corruption of peverse incentives

All that is true, and unfortunate. Personally I just see it as doing more good than harm, especially if the revenue raised were to go to harm minimisation services, like if the alcohol excise were used to fund alcohol addiction treatment services.