There are two purposes to a sin tax: reducing consumption or compensating society for the loss caused by the sin. A perfect sin tax is set at such a level that no one needs to care which one occurs.
If a soda drinker inflicts $0.03 / soda on society, the perfect sin tax would also be $0.03. In such a regime, I don't care how much soda you drink since you are paying for your own health care via the sin tax.