Imo public opinion has to align against police misconduct for it to be dealt with. If the public is offended by misconduct not being punished, this provides both an incentive for elective officials to make sure that can be done, and to police unions to be pragmatic about which kinds of interests they wish to defend; it may not be in the members' collective interest to defend a few bad apples, especially if doing so greatly angers the public. Of course, it might be in their interest if the whole lot of them are bad apples...
My impression, though, is that the majority of Americans are hardly concerned about police misconduct, and generally support the police against complaints, which doesn't provide very fertile ground for anyone interested in pushing reforms. You can win an election by being tough on crime, but can you win an election by being tough on police misconduct?
In a democratic system, whether a major crackdown on police abuses happens depends to a large extent on whether there is actually public support for such a crackdown. Is the current situation that there is strong public support for a crackdown, but FOP lobbying is keeping it from happening? I don't think that's the case; my read is that the majority of people actually think the police are basically good guys who shouldn't be hassled more. The dissenters are a mixture of left-wing/minority-activist groups who are suspicious of racial profiling and police abuse directed mainly at minorities, plus some libertarian groups wary of increasingly militarized policing. But afaict by far the majority opinion thinks those concerns are overblown and supports the cops.
But the union would not defend me if their lawyers thought the dismissal was according to procedures and with sufficient evidence; it's not considered in the union's interest to defend clearly bad employees, and in practice they object in only a minority of dismissals. Even when they do lodge an objection in a given case, there is hardly any guarantee they will prevail. Why don't police unions work like that? My guess is a mixture of factors, relating to both cultural aspects (the "no snitching" culture) and ineffective oversight or even outright collusion from people who are supposed to be their adversaries in such procedures, such as judges.
[1] http://www.dm.dk/da/OmDM/Organisationen/English