This kind of questions are great conversation starters, like my uncle has a Walmart battery that lasted 25 years and well my Optima lasted 45 years, without any real outcome IMO but here's my opinion anyways.
Buy a AGM battery so that you don't have to worry about acid leaking and you can install in any orientation.
So the real question to your question is, how many years of warranty do you want to afford? because it seems like they all die just past the warranty period. I personally buy the 4 year warranty Duralast Platinum from Autozone, they have great CCA and haven't had any issues inside the warranty period.
For my buggy I have a Optima Yellowtop that has treated me great but time will tell, that one has a 3 year warranty.