I don't see anything wrong with desiring good LEO's on the streets. That is what citizens pay for. It undermines good LEO's when not so good ones are allowed to police the streets.
Bad LEO's are making the streets even more hostile. The muni's are already on tight budgets, so it would only help to be rid of LEO's who are fraudulent in their duties.
In the Armed Forces, we can get less than Honorable Discharges when we are derelict of duty. This is another very serious issue that pols do not seem to want to tackle.