"Sued" or "bad boy" is a lot different from being arrested.
If you are prosecuted, the first step would be an arrest.
Its not totally rare for a officer to get arrested for either violating civil rights or, if they acted recklessely, going into the wrong house if they went in, under illegal circumstances.
The Bronx in New York has absolutly no problem prosecuting cops, even when it is wrong and stupid to do so, simply because the DA there hates cops.
It does depend on the situation. I remember last year when the cops here in NYC broke into the wrong place and a woman died of a hear attack.
The only reason the cops didn't get blamed was because the judge screwed up the warrant and gave them one for the wrong address.