IMO, it seems like a poor plan to rely on the revenue from excise taxes on particular luxuries (harmful or not). It's not a stable source of revenue, because increasing the tax will decrease use somewhat, and also acts as an indirect subsidy for alternative behaviors and grey markets (that you would also probably like to oppose if you are against the original one).
The only scenario that makes sense is to fund programs to help people deal with the negative effects of consumption (as, theoretically, such programs would not need to exist once consumption stops). However, unless you don't believe in addiction at all, it's clearly immoral to tie funding of treatment programs entirely to excise taxes.
So you have to weigh a revenue offset against the morality of, again, taxing people who may have compromised agency to one degree or another. I think our system does less ethical things all the time, but it's hard for me to feel these kinds of taxes are "well founded."
If we had real universal healthcare (or better cost sharing) then I think a much broader tax on things that have predictable health impacts might be sensible, but for it to work it would need to go far beyond "morally questionable" things and into, say, taxing companies that employ people to do labor that will reliably damage their bodies.