I keep waffling but always come back to basic flooded lead acid for best bang for the buck.
What is needed out of house batteries is ampere-hours, as measured by the industry standard 25 amp draw test. 6 volt GC2 size are in the 205-235 a-h range. This remains true with AGM's, less true with gel's, and both the latter cost more.
One thing I looked into last week was using size L16 instead of GC2.
Footprint is the same, but L16's are 16" tall (GC2's are 11ish) so if there is enough vertical height in the battery box they are a dropin.
a-h rating is 405 to 450!!!
Alas, my battery box has the height but there are some boards, boxes, and solenoids mounted around the edges that intrude into the needed space :(