For that application, I'd think the best batteries would be something like a Panasonic (or similar) OEM batteries that are made in Japan. With service caps/knobs and white semi-translucent housing with min/max level markings to replace lost water. I haven't seen an American made battery like this since the early 80s, although those usually had flush-mounted caps without any knobs (needed a screwdriver to take off/tighten).
Obviously a lot of new cars end up in a dealer lot for some time without being driven/charged and they have to be able to survive that. These factory style batteries might have a lower CCA rating, but that's not going to be a problem in a warm climate. And some dealers actually sell these factory style OEM batteries.