No, its not worth a drug bust. Im not even sure there IS justification for no-knock.
Im sure theres enough creative folks in law enforcement to bring these situations to a close without killing half of the involved parties.
The only justification for dynamic entries shoud be hostage situations, or active shooter/knifer/baseball batter/etc. Anything else really isn’t that urgent of a situation to require such action.
In addition, swat activities should be under elected officials, so only within the Sheriff’s department. Every little podunk town doesn’t need a swat team, unless it’s specifically for SaR activities or similar. Maybe some major cities (Dallas, NY, LA, etc) can keep their teams/equipment, but only with the approval of the Sheriff, and they have to go through him to use it.