Think of choosing a drone as a bit like choosing a car. You may need a cheap economical car, or a fast car, or one that has space for 6 adults, so you need to define what you need the car to do to guide you towards the best one for you. There's a good range of good drones and no single drone is the perfect solution for everyone. I think the generalisations below hold reasonably well:
I'd suggest going straight for the drone that suits your needs rather than starting small and growing, assuming you're not too financially constrained, otherwise you may find you need to upgrade prematurely.
- If you need utmost image quality go for a larger drone like the Mavic 3
- If you expect to be flying in very windy conditions lean towards the faster (and usually heavier) drones. Outright speed is needed to fight wind, weight aids in stability in that wind.
- If you travel a lot then look at the smaller offerings (Mini2, Mini 3, Zino mini pro etc). Sub 250g is an advantage in many countries, and the smaller size/weight makes it easier to pack
- If you need speed and agility then perhaps consider the FPV-style drones like the Avata.
I'd suggest going straight for the drone that suits your needs rather than starting small and growing, assuming you're not too financially constrained, otherwise you may find you need to upgrade prematurely.