They definitely need to be safe for indoor use so they can't vent, they should probably support deep cycling due to the nature of backup power supplies, and I imagine they should have relatively long life under near maximum charge to be ready.
Do most manufacturers use some flavor of AGM batteries? Any NiFe due to the robust, long life? Are they customized in any way that makes them different from a typical deep cycle AGM you'd buy at the hardware store?
I'm interesting in building my own (non-solar, just grid-tied) indoor backup power supply and I imagine whatever batteries are used by UPS manufactures would best since our requirements match almost exactly.