Best battery life for me has been an Optima red top starting battery. It ran 16 years in my old GMC 1 ton.
I have those spiral cell AGM batteries in a lot of my equippment (Optima and Exide Orbital) they are very long lived and being sealed, no corrosion.
Sadly, the price is getting crazy. The optima red top increased from $150 to $185 in 1 year :(