Moderna: 0 severe cases in the vaccinated group, 11 in the placebo group: https://www.nih.gov/news-events/news-releases/peer-reviewed-...
Pfizer/BioNTech: 1 severe case in the vaccinated vs 9 placebo group (https://pubmed.ncbi.nlm.nih.gov/33301246/)
Oxford: 10 hospitalisations all in the control group (https://www.thelancet.com/journals/lancet/article/PIIS0140-6...)
No they drop by 60%-80% or so, they don't drop to zero. It depends on the specific vaccin and which "refresh" regimen you choose, and of course on your age (the very young and very old can get as many vaccins as they want, it won't work, and of course immunodeficient patients won't work either)
Or to put it differently: if you have to choose between stopping smoking or getting vaccinated. Stopping smoking is by far the better choice (of course both is still better).