>I suspect those are constitutional when the are properly targeted to a specific event/person/etc. The tactics used to implement the search isn't limited by the warrant.

Almost every no knock is executed in such a way that 'proper' targeting is impossible.

A warrant cannot magically excuse police from their improper conduct. It took a deaf dumb blind and ignorant bench for that.