Like you I have been on the lookout for a "good" camera drone. I have played a lot with a phantom 2 Vision (until it self destructed) and then was lusting after a Mavic pro. The spark was also on the list but then the lack of raw capability was a real negative. The Mavic air then started to look like it ticked all the boxes. The problem for me though is the cost... And after my experiences with my loaned P2 Vision I am really unwilling to spend a thousand Euros (Mavic Air fly more combo) on something that can be a total loss in a couple of seconds.
I really don't need much video capability, I don't need huge range as my use is more about sending the drone straight up to capture landscapes from a higher perspective.
With this in mind I got a used Phantom 3 Std with two batteries off eBay for less than the spark with no controller.
It shoots raw, has a decent flight time to play around with framing and make panoramas. As I don't really do much video with drones the lack of advanced/autonomous flight modes is no big deal. I figure that if it lasts it will allow me to get what I want to get until in a couple of years a more portable solution with a 1" sensor is an option. At the end of the day I don't see massive differences in any of the tiny sensor drones in terms of image quality (at least for stills) so for me it is probably the most cost effective option. The size is a pain, but I suppose that is the tradeoff... However most of my use with the drone will be generally with a vehicle or boat or short walks so I can live with it. Airline travel though is going to be a mission...
I was fairly happy with some of the output from the P2 Vision:
I am really looking forward to playing around with the new-to-me P3 over the next few days with a trip to the Austrian alps. Just my thoughts on other possible routes to explore in terms of drone purchase and hop it can be of some help.