The first video link here has had a serious influence on me and my drive to push for advanced designs and concepts. This is Raffaello D'Andrea, in a "Ted talks" video. )Note that the camera will repeatedly focus on Bill Gates in the audience) He shows the totally awesome possibilities of drones/multirotors, and I do mean "awesome" in its original meaning ! They do 'cheat' a little to do this - note the little white balls to help the video reference to make it all happen. That being said, this is amazing and even a little scary as to the potential...
Here is another example of advanced design and concepts - it may seem to some to be kind of a gimmick, and may seem to others to be scary as to its potential use or purpose. A drone that can "Snatch" things:
This is a similar concept that is more practical than scary, a drone that can perch on a branch:
I wonder why they designed it to perch the way it does, it looks like it would be off balance or need a lot of grip to be able to do this reliably:
I was tempted to post videos about drones carrying firearms, only because is fits the description of being "scary", but no need, especially since DIY Drones has a policy against weaponized drones.
When I am able to search again, I will post more in the way of "Advanced to the point of scary".