I see a lot of people outraged and making emotional appeals. The wake of a tragedy isn't usually the best time to pass legislation, or even form a coherent opinion. There's an estimated 8000-50,000 no-knock raids per year (sources have numbers all over the place, Vox seems convinced it's 20,000) and since 1980, only 40 innocent bystanders have been killed. Overall, the risk of either an officer or civilian dying is ~1/1000. I'm not finding any good sources on how many people are arrested, or what the warrant is typically for, which is important to weigh the benefits. Incidents where they get the house wrong or an innocent person is hurt are newsworthy because they're rare and they can rile people up along political lines and push an agenda.
If there's a warrant for a dangerous person's arrest and you expect them to fight back, I'd rather that be in a no-knock raid in the middle of the night at their home with 50 police using military hardware, than one or two cops at a traffic stop that turns into a high speed chase/shootout in a busy public area.