And, for Bonus Fun Points, qualified immunity will protect the person who did screw up from ever having to be accountable to the people who were terrorized as a result of his incompetence.
And that's right there is part of the problem. If you put the wrong address on the affidavit, then you should be held responsible for anything that goes wrong during the execution of that warrant.