Interesting rabbit hole. I bought an Engel dual 120V/12V powered fridge. Runs off 120VAC and 12-24VDC. You can plug it into both and it switches automatically to 12VDC if the 120VAC drops out.
Things I've noticed. Even high efficiency residential fridges aren't that efficient. Some off grid ones use three times less power. And lot of the modern fridges have inverters to drive the compressor. Which means would not that big a stretch to add a 12/24V input like my portable fridge.
I mention this because not all household loads are the same. You really don't want your fridge to stop working. You probably can manage if you can't run you whole house air conditioner full tilt.
Having appliances that can run off back up and ones that can adjust their load probably would help.
Another random opinion is a lot of house wiring could be replaced with Power of Ethernet. There is a new automotive standard that provides up to 100W. A house where lights and light loads were run off POE could be trivially backed up by a battery.