I'm really not sure how often officers violate the standard; it wouldn't shock me if it were frequent

But when they do, courts will suppress the evidence, and anything that's obtained from knowledge gained in that search ("fruit of the poisoned tree").

I trust that mechanism. And think it's likely better held in the US than literally any other country (v open to evidence to the contrary though)