I bought two new Optima Red Tops at the same time. One went in the Vette, and one went in the TBSS. The Vette doesn't get driven very often, which is part of the reason for choosing the Red Top. It is supposed to be better at handling the infrequent usage. Always maintained over the winter with a Genius or NoCo smart charger.
The TBSS was a daily driver, so there was no need for a charger, and I never had an issue with that Red Top. It was a great battery for 4+ years. The Red Top in the Vette is done. Won't take a charge even off the smart charger at all any more. So it clearly depends on your usage.
I'd just like to add that in my Trans Am that I have had for 13 years, I use Canadian Tire Eliminator batteries. It was simply a convenience thing when I was up north and didn't have a lot of options and needed it right away, but I have not been disappointed. I have replaced it twice, both times replaced for free under warranty. I have left it connected and in cold storage over an entire winter twice, and the car started without a boost in the spring. It's not as pretty as the Optima, but it works, and if it doesn't, I get a new one for free. To wit: I do believe they have stopped the lifetime free replacement program now, but they still have absolutely excellent batteries.