The problem I have with drones is with surveillance. They make it too easy to violate privacy in places that have an expectation of privacy. So, the only way I would be fine with drones flying around is if I was allowed to own the airspace above my house.
Short of that, I don't want the government or private individuals flying drones around.
As for the extreme examples, I really can't see local law enforcement laying out tons of money on these things for singular rare purposes that could be solved in more mundane ways. I could see them buying drones as multipurpose, but one of those purposes is going to be surveillance.