SWAT tactics are appropriate when you're using their inherent violence to defuse an already violent situation. When they're used to serve drug warrants, you're creating violence where none existed before. The consequences are predictable. People die—cops, drug dealers, people mistaken for drug dealers, and bystanders.
http://reason.com/blog/2011/01/06/more-on-the-botched-drug-raid