This [0] says that as a light (1 drink a day?) drinker, different types of cancer have a 1.04-fold to 2-fold higher risk of cancer, depending on the type of cancer
Then I found [1] saying that being cigarette smoker gives you a 25-fold higher increase for lung cancer and 2-fold for bladder cancer.
Considering amounts, and types of cancer, that seems almost incomparable. Though cigarettes sound really bad, and I’m glad I quit with vaping ;)