With that being said the absolute worst thing for a normal car battery is for the volts to continually run down then charge back up. This will ruin your battery quicker than anything. A normal car battery is not made for this and it will eventually not hold a charge. You take a typical marine battery that is made strictly for boats and particularly trolling motors they are what is referred to as a DEEP CYCLE battery. This type of battery is made to constantly lose the charge and then be fully recharged. That's one of the reasons that a marine battery is more expensive than a car battery. That is why I use and suggest a battery maintainer especially if it's a vehicle that will sit for a few days or more. The maintainer will keep your battery fully charged. When it's connected it will trickle charge the battery until it's fully charged and then go into a stand by mode. When the battery starts to lose its charge it will go back to charging mode.
I agree, but with a couple caveats.
1. Lets be clear on the terminology and uses.
Deep cycle batteries are designed to provide power over longer period of time, but at fairly low current rates. For example a group 29M deep cycle batter will provide 15 amps for about 6 hours or 5 amps for about 19-20 hours.
They will not develop the cranking amps needed to start a large automotive engine in cold weather, and trying to draw too many amps from them can damage the battery. They also need to e charged slower and over along period of time than a car battery.
Car batteries on the other hand are designed to provide a very high discharge rate of up to 1000 amps. They are designed to dump all their stored energy in a very short period of time. Under normal service they dump a lot of amps quickly starting your car and then recharge very quickly and 50 to 70 amp alternators are common on passenger cars today.
There are also dual purpose batteries that can provide both a number of minimum cranking amps and cold cranking amps, and maintain a lower rate of discharge over a long period of time. They do both tasks but won't do either one as well as a dedicated battery.
2. Not all "trickle" chargers are created equal.
Battery maintainers or smart chargers that monitor voltage and charge rate and cycle through a main charge, a trickle charge and a maintenance "float" charge phase where it keeps the battery topped off without over charging are a good thing.
Trickle chargers that just charge at a constant low rate are much less expensive but absent some form of internal or external charge controller, they will fry your battery.
Also, smart chargers respond to the battery's voltage, so if you get a cell that starts to go bad, the battery's voltage never gets high enough to kick the charger into the float mode, or if the cell is bad enough it will stay in the main charge mode. Either way, what you have then is a trickle charger that fries what is left of the battery. So if you notice that your battery maintainer / smart charges isn't kicking down into the appropriate mode, it's telling you you've got a bad cell. Ignore that at your peril.