They use flying drones all the time, you can see them flying around in the Starbase live streams. I can't think of anything off the top of my head that a flying drone can't do but spot would be able to do at Starbase. Unless Spot can crawl into a pipe or tank maybe.

Like I said, Spot can do one thing that the drones can't: Get more upvotes on his Twitter post showing how futuristic he is.

An oldie but a goodie, heres one of my favorite displays of how "ahead of the curve" Tesla is:

https://youtu.be/ib1KKHGYmLQ?t=1689

Anything that involves adding weight to the robot (e.g. carrying something from point A to point B) seems like something more suited for Spot than a camera drone.