In my opinion, and I am NOT an expert, But "any" right size battery should do, as long as the alternator is up to the task, who I think often is not big enough on older cars. Especially after installing a lot of stuff like Electric fans and modern injection and so on. And overnight drainage is also often the culprit for bad batteries.
And the battery must also be big enough, especially for Winter use too.
After all that is made right, then I Guess you could choose wether you want an modern type mini battery for weight savings, who also would look cleaner and can be tucked more away.
Or else any standard (right size) battery should do it. Of course, some will always be cheaper and some not so good as others -But I dont think thats the MAIN reason for battery failures
I have an Red Optima battery in my car, an old alternator, dont know size, probably 60-70 amp. I "just" bought the car.
I have an Electric waterpump and fan, it just keeps up the voltage until the fan starts, then it falls flat on it face and cant keep voltage up. - Very classic hobby-car mismatched charging/electrical use system..
It has been sitting for a while now, Wonder if it will start, With what People have said about Optima batteries