It's quite effective at preventing serious illness and death, which is the whole point of the vaccines. It's even better if you don't get sick at all, but unfortunately not everyone has that much luck by being vaccinated.
Historically the point of vaccines have been to prevent transmission. The covid vaccine is distinct on this.
> If you can prevent that, then you can likely limit or eliminate the spread.
That doesn't make any sense. Mitigating serious illness puts no downward pressure on transmission.
And in fact, if someone's symptoms are reduced and they don't need to test because they aren't required for vaxxed, it may even encourage spread.
You are right that this could be offset because there is no isolation happening in case of an unknown infection.