Now a days, "good" is basically having enough restraint to not tase an old grandma or shoot somebody's "dangerous" dog.
And you are probably right. I bet there are 100 good cops for every asshat cop. But, all it takes is a few rotten apples to spoil the bunch. And that doesn't sit so well when it comes to enforcing laws.
I remember the one time my high school g/f and I, along with her brother got pulled over for speeding. We happened to have a cooler in the back seat. Four cops later, a nice frisking, a phone call to my father from the police letting them know we had, GASP!! unopened beers in the car (that they poured out in front of us, lol) and about an hour of our time, we were finally let go.
Even though they were "just doing their job" they were total dicks to me. One of the cops taunted me the entire time. One thing I don't envy though is being a cop. Just by being one, good or not, you are automatically hated.
How many people do you smile and jump for joy when they have interaction with the police?