which drones are preferred for aerial photography and what makes them suitable for that?

DJI Inspire, preferably.

What you are looking in aerial photography is the answer for "what makes them suitable".
Whomsoever provides what majority of customers want in aerial photography will be the market leader.

So define what you want which could answer you questions.

As mentioned above purpose is the first thing to define...
Inspire is good but expensive..
Mavic is good cheap-ish but has weather limitations..
Phantom also good...
For long range aerial photography and mapping Skywalker, volantex ranger, MTD, skyhunter,
O Karna ki Hai yaara ...

Dji matrice 600

The author doesn't seem to update his requirement. This may help: https://uavcoach.com/drone-with-camera/

It includes all kinds of drones available in the market for photography. Of course, some of the ultra high end ones are not listed, if your budget is pretty fair, then this will do.

I think Inspire's price is actually worth it for people who intend on using it a lot. For someone who's just getting into this and is unsure about what they need, I'd recommend cheaper options.

Flew a phantom 4 pro today , a guy at a wedding was flying it. We talked a lot about rc and discussed whether clover leaf antennas were good or not and we talked why phantom 3 is a horrible drone. P4 is a great drone if you are willing to shell off  a good amount for it. I think the footage is also pretty good for night shooting. P4 is pretty stable too. I think p4 pro will not let you down.

@
Flew a phantom 4 pro today , ,,-"
Damn u r lucky ....
I've only ever seen that thing on yt....
Would love to see it or the inspire in person

Here we are providing all details of Drone Camera Price in India, check it.