Ah I’m glad it came back on!
If power outages are fairly common than I would definitely look into a proper generator. I may be biased since SO is an electrician, but my recommendation is to purchase it from a licensed electrician and have them install it. Have them maintain it for you.
Around here there are dealers who can’t actually work on the generators themselves, they get someone from out of town to install them. Then when there’s a problem they tell the customer “sorry, can’t help you”.
The power has only gone out once at our place in since we’ve lived here. We just have the smaller generator that SO takes to job sites.
The power goes out at my parents farm several times every year, and can take days to get restored. They’ve got generators hard wired for the house and barn.