Which camera to use for drone hobby photogrammetry

Hi All,

In the process of building a 500 sized hobby photogrammetry drone powered by a Pixhawk 4.

I am fairly new to drone photography and would love options on which camera to purchase.

I already have a GoPro Session 5 which I use for FPV but I don’t think this has the specs to do photogrammetry.

Should I look for an older GoPro Hero 4 or 5 camera as I have read that they do the job. Do the newer GoPro Hero’s work.
I have read that the Hero 7 & 8’s get very hot.
Also read an article about the SJ8Pro. Is this camera an option?

Would love some feedback. Thanks