Do you have any family members in law enforcement? You'd be dooming them to death by absolutely outlawing no knock warrants just to give Obama's sons an edge.
As for "middle of the night." I don't know if that's true. In Texas, warrants are not executed at night. And I have never seen a night time raid on body cams despite viewing a large number of them.
No, it’s not worth a drug bust. I’m not even sure there IS justification for no-knock.
I’m sure there’s enough creative folks in law enforcement to bring these situations to a close without killing half of the involved parties.