What's best for a given household varies of course, but thought I'd add a couple of comments since I live in a remote, rural area subject to frequent outages and fluctuations.
I'll echo a couple of the above comments regarding using UPS units to insure minimal recording interruptions, particularly if power outages or fluctuations are more than an occasional event.
If you're interested in a system that's as robust as possible, multiple UPS units are needed. One or two should cover your infrastructure (servers, routers, switches, APs, cameras and the like), and then individual units for key locations where TVs and streaming devices are located.
Beyond that though, I find that orchestrating those UPS units is the key -- meaning the setup needs parameters. These include how long after the switch to battery before an orderly shutdown begins, and how long after power returns before systems are booted-up.
The best designed setups require zero user intervention, with equipment powering down and up again whether you're home or not. I extended a couple of existing open source projects based on docker versions of apcupsd, apcupsd-cgi and Grafana to meet my own needs -- which have since been downloaded from Docker Hub thousands of times.
A few APC UPS units, with an SBC running off a USB port on each, and you pretty quickly turn power outage chaos into order!