If they're at the wrong address, then a serious tragedy and a massive lawsuit are probably what will happen. And one or more officer's careers should be finished too, at least.
Because of the serious implications of these actions, there should be double, triple and quadruple checks by multiple individuals before the door is breached. Maybe someone from the AG's office should come along in the vehicle as non-LEO eyes too.
Like the stories of surgeons amputating the wrong limb and such, mistakes in this area should just never happen.
Wrong-address raids happen. Very seldom is anyone punished. Given that police departments are unwilling to punish wrongful no-knock raids, they shouldn't generally be allowed such raids at all.