Could it be that the problem is not the individual police? Perhaps the men and women who wear the uniform might not be the problem and are simply facile scapegoats.
In each of the police deaths and injuries (including the police dog) the officers were left to themselves in a complex situation - no external support, no command interaction, no leadership involvement; they did what they could with what they had, all by themselves. In both cases, with a man trapped in a basement they did not secure the perimeter and call in their sergeant, commander, SWAT or a negotiator; they went in themselves and the results were tragic. They were not working in a culture that expected them to call for more help; they were not trained to call in more assets.
In the recent Pride Parade situation, a relatively low-experience officer was left standing alone between two angry shouting crowds, without any support, until the inevitable finally occured. (and to really understand the Pride Parade situation, one might do well to read Shooting an Elephant, by a policeman named George Orwell).
In each of the cases where a citizen was beaten in situations the community finds unacceptable, the officers were operating without supervision, without videos or accountability, in a persistent context where they're on their own, results are rewarded, and their official reports are taken as gospel. (Until somebody finds a video). Is anybody surprised that a few bad actors surface in this environment?
Could it be that instead of having bad Police, we have 98% good police in a bad Department? By which I mean - bad management, bad supervision and operational oversight, bad training and procedures? Bad leadership? Is the media and public and blogosphere blaming the troops when we should be blaming the brass? Could it be that Pittsburgh has mostly virtuous Police officers in a bad, dumb, disfunctional organisation? I think it's quite likely.
Could it be that over years of tight budgets and leaving these police officers with nobody to look out for them but each other, the FOP has become their only refuge? In that situation, would the FOP seem resistant to change and wary of the several administrations that have allowed the situation to fester?
Could it be that we're not paying the police officers enough - so they have to earn money on secondary details which they run themselves - and has our failure to pay a fair wage produced the corruption of uniformed cops working in strip clubs?
How do you fix this? You have to change the culture, the reward system, the leadership, and flush out the bullies and tyrants that developed in the vacuum. But the first step is: you have to acknowledge that it's our fault, and not any one officer's fault; and you have to know that you don't fix anything by declawing the only bulwark they have.