Your instinct about Gatlinburg is well-grounded, and your skepticism about Scottsdale is also well-grounded. Those are actually two different questions, so let me take them separately.
For the Gatlinburg cabin: aerial footage earns its cost most clearly when it shows something a guest cannot see from street level or from inside the property. A ridge view with surrounding forest or mountain scenery is exactly that situation. The guest is paying partly for the setting, and if your listing photos cannot show the setting, you are asking them to imagine it. A $275 add-on on a property that probably books at $150 to $300 a night needs to recover maybe two nights of margin over its lifetime to break even, which is a low bar.
For the Scottsdale subdivision: a drone shot of a roof and some identical neighboring rooftops does not tell a guest anything useful. You are right to hesitate. Ground-level and interior photography will do more work for that listing than aerial will.
On your broader question, whether guests book differently because of aerial footage, I am not aware of any controlled study that answers that cleanly for STRs specifically. What I can say is that aerial footage functions as a signal: it tells a guest that a property has something worth showing from above. When that signal is true, it attracts the right guests. When it is not, it looks like filler.
One thing worth checking before the Gatlinburg shoot: confirm the photographer holds an FAA Part 107 certificate, which is the commercial drone license required by federal law. An uncertified shoot can create liability for you as the property owner.
What platform are you listing on, and do you know roughly what your Gatlinburg booking rate looks like right now?