"The RV batteries are designed for longer current discharge, not like automotive batteries designed for short bursts of high current.
Theyre also called golf cart batteries."
Yes and no. An automobile battery is properly called an "SLI" battery. Starter, ignition, lighting. Designed to be discharged only a few percent before the alternator recharges it, using a design that is actually intended to "not overcharge the battery" during long highway runs. They are built with thin plates, to provide more plate surface area, which provides the high impulse power for starting motors.
In contrast, a deep cycle battery is designed to be cycled to a 50% depth of discharge. (30-80% typical range with varying numbers of cycles) In order to provide the deeper discharge and still reform the plates during recharging, they use much thicker plates. One extreme of deep cycle batteries are TRACTION BATTERIES, i.e. those used to run the electric motors in golf carts, aka golf cart batteries. And they are built very rugged, because they are heavily cycled in normal use. They are also used in small electric fork lifts and other "traction motor" applications.
"RV" and dual-use batteries are a compromise, and if you're not starting engines and giving them light use, don't waste your money.
AGM batteries are good because you can't spill acid with them. And bad because if you boil off electrolyte, you can't just top it up. More expensive than wet lead, and arguably not as robust as deep cycle wet batteries. But again, there's no acid hazard.
Lithium batteries (of any type) are problematic unless you're willing to be very careful with chargers, or buy a very expensive system. Lightweight, no acid, powerful, but expensive and easy to ruin.