Actually, I've long been of the opinion that such taxes can lead to a "dependency on the dependency." That is, while a government may intend to discourage the "undesirable" activity it's taxing, it may in the long run grow to depend on the revenue that tax generates, which may in turn reduce incentive to discourage that activity in more effective ways, like anti-smoking or anti-drinking campaigns. After all, do you really want to discourage the activities that build up your revenue?
Now, let's consider the payroll and income taxes Mr. Frank laments for discouraging job creation and investment. While this may be true, maybe our government could develop campaigns or programs to encourage these activities, and so counter the discouraging effects of taxation. I don't know off the top of my head what such a program might look like, so I can't say how feasible it would be. If nothing else, though, the potential for even greater revenue from increasing desirable activity sounds like a fairly strong incentive to me.
I'm no economist, so maybe this "addiction to addiction" hypothesis is just another crackpot theory. I'd be interested to hear if anyone competent has actually explored this?
[slight edit for grammar]