I used "the best/expensive" battery in the past but stopped using them a few years ago. The price/return ratio just didn't seem to be up to my expectations. On a whim I switched to the Advance Auto Parts brand of batteries (silver/gold.) While I have had a few bad batteries in the past few years, all were replaced (not pro-rated) when I took them back. I like the service and warranty that I get from Advance. Most seem to last around 5 years before they start to fade. Replacement is around $100-$150 on average which is not bad to me.
Motorcycle batteries are another thing. I have yet to find one that will last more than one or two summers.