In reply to StefanB:
So, given all the uncertainty about how much I will actually use it, I decided to first get something cheap and see how I get on. So I went and bought a Mavic Mini yesterday (combo) and went to try it out on a beach at sunrise today.
Mixed result:
Camera: I didn't expect much in terms of quality and was worried about the lack of RAW support. But the jpeg's come out surprisingly well and underexposing them a bit leaves some wiggle room in Lightroom. Better than a GoPro and probably similar to an iPhone 11. So quite pleased with the photo quality for the price.
Flying: So it turns out it's quite easy to fly the thing, but it loses connection to the controller fairly easily. Range seems to be about 70-80 meters (250-300 feet?), I was expecting a bit more. Another worrying thing is that above the water it suddenly stopped hovering twice and started a slow descent. This is a bit worrying. Maybe it was due to some low light and reflections of the rising sun on the water.
Logistics: Quite a bit more compared to my usual photography excursions. First I needed to drive 45 minutes to escape a no-fly zone, then I needed to find a spot to be on my own (I didn't think it would be a good idea to fly above the early morning fishermen). Then there is all this plugging in batteries, unfolding and connecting of stuff, synching up things, and changing batteries. I am quite a photographic minimalist, opting for lightweight gear (one camera, max 2 lenses, ideally no tripod) for simplicity, so the drone stuff might get annoying in that sense.
Anyway, thanks for all the help on here! I suppose I will either get bored of it or invest in an upgrade at some stage.