This comment from the SFWeekly "Turning the Tables" article really sums it up:
Cops who get in the spotlight because of problems -- whether it's their fault or not -- need to be re-assigned to alternate beats. "The appearance of impropriety" hurts good cops trying to do their everyday jobs. Like it or not, good police work depends on trust from the community. When a couple of high-profile cops get a bad rep and start causing trouble for the rest of the force, they need lower profile jobs.
they need lower profile jobs.
Perhaps in a different career field.
It's nice to see some good news for a change!