I tend to prefer AGM... But that's use-case dependent.
AGM is more friendly to lower temps, vibration, and deeper discharges without hosing the battery. They also tend to (but not always) have some lower internal resistance and will charge up quicker for short trips. Fits me better
If none of those apply, then pocket the extra cash and get a traditional flooded battery.
tbh if you really want your battery to last, get an on-board charger from noco or something. Plug the thing in once a week to get it a proper full charge. The chemistry of a lead-acid battery really, really, doesn't like to go in the reverse direction and even at 'full charge' - it takes hours upon hours to fully go to reactants.
Electrical loads is..... Not really specific to anything. Once the vehicle is started, the alternator takes over. Unless you have aftermarket accessories that can exceed alternator output, then that point is moot. Just need to start.
FWIW my current battery is from 2017(I think? Need to check manufacture date) and still operates as intended. Haven't noticed it getting 'weak' yet. Superstart platinum agm from Oreilly's. I did zero market research on the thing, I just needed a battery and that's what they had. I don't buy into Optima's cylindrical nonsense - inefficient packing into a cuboid form factor.