Confused about battery types – AGM vs regular for a daily driver in this heat

Alright so I’ve been down a rabbit hole for the past two days and my head is spinning. My 2018 Jeep Cherokee needs a new battery I think because the voltage has been dropping to like 11.8 overnight according to my little dash meter. Started looking into replacements and I had no idea there were so many choices. Some people swear by AGM for hot climates because they handle deep cycling better, others say standard flooded is fine if you don’t have stop start which my Jeep doesn’t. Then you’ve got different CCA ratings and warranty lengths and frankly I just want something that won’t leave me baking on the side of Sheikh Zayed Road in August. Found Battery Zone UAE while searching for local suppliers and they seem to stock multiple brands which is nice, but I’m not sure if I should just trust whatever they recommend or go in knowing exactly what I want. Anyone here run AGM in an older car without stop start? Is the extra cost actually worth it or am I overthinking a simple battery swap? Also curious if heat kills AGM faster than standard ones because I’ve read conflicting things. Send help.