Hi Poly.. my thoughts are
If you google “best action camera 2021” (and I have done that for the past 6 years) .. the number one slot in ALL the review sites..EVERY year without fail is.... The Gopro. I appreciate some users swear by different brands ..but IMO the review sights are not far wrong
For my videos, I use a Gopro 6 and the karma gimbal for steady boat footage. I also use a Sony FDR AX 53 for Zoom shots and its on a tripod on firm ground. Very occasionally I will use it without a tripod but you can tell as the footage is shaky. Its no use for action shots though as its not waterproof or shockproof like the action cameras.
IMO The Gopro is ideal for the use you mention as its now waterproof without needing additional accessories. The Gopro 9 has great stabilisation and is almost as good as a gimbal held camera.
Personally when using the Gopro, I keep the Gopro on linear mode as Im no lover of the wide angle and distortion of its wide and ultra wide modes. It doesn’t bend the horizon as much in linear mode.
I have kept away from them simply because I used to fly scale R/C aircraft at competition level. As such, I know how vulnerable model flying objects are when controlled by human hands and aging eyesight. I know plenty of folks who have bought drones.. and lost them due to crash landings etc. I also don’t know anyone who has bought a drone and not lost one.
If I could get a drone guaranteed not to crash..I would consider it but even those DJI one costing well over 1K quid are lost.. so choice is yours ..
So saying.. as you may know .. I have lost expensive DSLR cameras when they fall in the sea too..so perhaps I should get a drone. My thoughts are they are good for variety of shots in a movie ..but not for the whole movie. My opinion only.
Hope that helps some