I don't think we're going to get rid of S.W.A.T. type weapons and tactics entirely. One reminder about bullet-proof vest-wearing bank robbers with AK-47s will nix that. But, wow, yes, have they ever gone overboard with the APCs and heavy weapons and over-the-top entries.
The paramilitary approach has become standard. An infant was badly burned recently when cops announced their presence by flinging "flash-bang" grenades through the windows before bursting in with weapons drawn. No drugs were found. "Wrong house."
Oops. And it's not that uncommon. An anonymous tip can lead to a full-on action-movie assault, complete with explosions and guns to foreheads. If the residents get scared of black-garbed attackers breaking in and hesitate or resist, they are shot to death immediately.
The Constitution requires protection against unreasonable search and seizure. "No-knock warrants" began during one of the country's anti-drug freakouts, and were supposed to keep dealers from flushing all of the evidence before the police could enter, and to provide some extra protection from heavily armed criminals.
It's become just the way it's done. People and pets are shot when offering no threat; dangerous flash-bangs can cripple or kill. All so the police aren't inconvenienced by some flushed drugs or the smallest possibility of resistance.
If there isn't some kind of solid evidence that a suspect is armed and resistant, the police can knock and announce themselves. They can wait a short period of time to be admitted to the premises. They can refrain from throwing bombs through the windows.
They can find out if they're even at the right freaking house.