Your last sentence shows your thinking is very muddied on this. You should reassess. If 100% of people were vaccinated, then obviously all ICU patients would be vaccinated. What would that tell you about how well the vaccine works? Nothing. How can you possibly believe that would make a case for being unvaccinated?? Again, if everyone wore seatbelts, there would still be traffic fatalities. Would that be an argument for not wearing a seatbelt? That's essentially the logic you're employing.
I don't argue about transmission stats, because I haven't seen any conclusive data, most probably because it's almost impossible to determine if someone is infected by a vaccinated or unvaccinated person.
However, when it comes to lessening the risk of serious illness or death, the facts are in, the vaccine is very effective.
The way you are understanding ICU numbers you are comparing apples to oranges. As I said, the only way to do it is to compare equal size groups and see how many patients from each go on to develop serious cases of covid. It's the only measurement that matters as far as the vaccine is concerned.