If you want a shock, get on a jury. If you are lucky, one other jury member might require more proof than a cop's say-so.
Jurors were questioned about this during the voir dire, and several people were dismissed because of an admitted bias in favor of police testimony.
Obviously, this is a sample size of one and no generalizations can be drawn, but it does stand as a counterexample.
I'd give the word of a police officer "special weight" -- assume he was bitterly, hatefully, fraudulently lying through his teeth, even if just for the fun of it.
Sometimes I wonder what would have happened if you don't have that kind of jury..