The two major vaccines - Pfizer and Moderna, never tested for infection prevention. There was literally no data to even say if they did or didn't prevent infection.
You can look up the clinical trial endpoints. Patients were only tested for infections if they experienced symptoms. I believe it was only AZ or J&J that regularly tested to capture any effect on infection rate.
But it was stated several times "The vaccine will stop you from getting Covid". Why? Because if you tell people "Well, the vaccine won't stop you from getting it, but it will make it less likely you'll get really sick", they thought people wouldn't take it.
I didn't mention COVID. You're focusing on COVID vaccines because that is the anti-vax cause at the moment.
It's the case with ALL vaccines that they don't provide 100% protection. They are still incredibly useful for preventing infection, reducing the severity of disease and preventing further transmission.
Btw, vaccines work by clearing infection quickly, not preventing infection. The virus infects you and begins to multiply. Whether your body has the antibodies to recognize the virus determines whether you will suffer from illness or be well.
You suggested that the COVID vaccine was somehow bad for being like every other vaccine. I'm suggesting that you need to learn about vaccines and get vaccinated.