A lot of good comments here... I've been on a few raids and got called to back Tac on one where they did indeed, raid the house. The warrant had been applied for by an inter-agency task force and as nearly as we could tell, the error was a simple typo. The Tac guys had their heads on straight and almost as soon as they got inside, they realized something was horribly wrong. Nobody got shot and the city got to buy a new door.
There have also been occasions where the truth has been stretched in the warrant application process. In those cases, somebody needs to go to jail. I would support legislation, at any level, that makes 'false information on a warrant application' a felony.