CDC lab reports state that the vaccines are 90% effective at preventing Covid infection with both doses, and 80% effective with one dose. Not sure where you're getting the idea that they don't prevent it at all.
Regardless, I'm getting my first dose tomorrow, so yes, I'm getting it. 90% protection is still better than 0% protection!