The only situation where I understand a no-knock warrant is like when the police is actually targeting someone's computer and don't want to go through all the hustle of cracking the password.
Quit overthinking this.
Police "understand" no-knock warrants because judges approve them and there are no accountability problems.
You and I find it distasteful, but as long as judges keep approving the no-knock warrants at current rates, DAs keep using the evidence gathered from them, and defense attorneys can't get evidence gathered from them dropped from the case, all of the incentives align. Short of a massive cultural change, only a legislative restriction will change this behavior.