Now you can buy larger quad-copters than I had built off the shelf.
Things change , people get used to it, opinions morph.
When robotic dogs and bipeds become more common place, people will become less threatened by them just due to sheer anxiety fatigue, if not more friendly reasons.
My take : when I see a robotic dog I think "That's a corporation with a spending budget!"
That's considered reasonably effective by the militaries, and fully within the capabilities of many cheap quadcopters.
More advanced "loitering munitions" (essentially, drones that fly around until they're sent to slam into a target) were used in the recent Nagorno-Karabakh conflict.
I believe that all these cases were human-in-the-loop for various reasons, but the possibility for automated targeting seems reachable soon if the armies would really want it (which is not certain).
In another case, small CoTS RC planes did significant damage to a Russian airbase in Syria [1].
[0]: Death From Above: The Drone Bombs of the Caliphate https://www.bellingcat.com/news/mena/2017/02/10/death-drone-...
[1]: Russia Offers New Details About Syrian Mass Drone Attack, Now Implies Ukrainian Connection https://www.thedrive.com/the-war-zone/17595/russia-offers-ne...
There, I made you afraid of cheap $100 quadcopters off Amazon and raspberry Pis.