Each battery type generally has some pros/cons to it. Improper charging kills all batteries, quickly. If your charger is boiling your FLAs, it's a bad charger. (LiFePOs do worse things on a bad charger
)
Flooded batteries are generally the best bang-for-buck you can get, particularly the golf car batts. They handle abuse pretty well, best $$ per AH, easy to maintain, widely available, and generally long life if treated well. They need to keep charged and don't overdischarge for best lifespan. Obviously, they outgas and must be in the proper orientation.
"Maintenance Free" FLAs (i.e. ones that don't need to be watered) are generally low capacity, not deep cycle, and they do outgas too. These are different beasts than AGM or GEL.
AGMs have much better charge acceptance rates than FLAs. They'll die quick if not kept charged. They can be mounted in any orientation. They cost 2x for same capacity, most folks do not get 2x longevity out of them.
LiFePOs and Carbon Foam are great for the intended uses, read what Mainesail says for more info.
I'm a big fan of "one big house bank" with primary charging sources going to the house, and then a smaller 'back up' or a 'start' bank charged with an ACR or similar.