One possible way to reduce the errors (overall) is to make it so that while the city/county/state/etc., is responsible and pays (or their insurance pays) when found liable in court, the individual officers and their supervisors would have their wages garnished to pay back the city/insurance company, etc.
In some branches of engineering, people can be held criminally negligent for engineering mistakes which result in injury or death. An engineer who signs a drawing is taking personal responsibility for the integrity of the design.
If a person has a security clearance, releasing information into the public can result in prison time, even if the release was accidental. It is not necessary for the prosecution to prove intent, they must only show negligence.
If a US company has a contract to supply weapons or defense services to a foreign nation, these transactions are covered by ITAR regulations, which are very complicated and change yearly. Violations of ITAR are a felony, punishable by prison, and again it is not necessary to show intent.
If a person has knowledge about a company that would affect the price of its stock, knowledge that is not generally known to the public, that knowledge is considered "insider knowledge". If the "insider knowledge" is used by that person to trade stocks, or is exchanged with another for some quid pro quo arrangement, everyone involved could go to jail. Even people who had no idea that information would be used to trade in stocks are still criminally liable. Once again, it is not necessary to show intent.
All of these examples relate to negligence on the part of professionals... negligence that is punishable by jail time.
So why are we talking about garnishing wages, and suing the city? Maybe busting into the wrong house should be considered a matter of criminal negligence?
If Officers might be facing real jail time for errors in judgment, they might be more careful. Businessmen, engineers, airline pilots, surgeons, pharmicists, all can face criminal penalties for an "honest mistake" i.e. negligence... why not the police?