Sure, as long as you size the system to expected loads.

An 8kW generator suitable for occasional use is only ~1,000$. A Powerwall 3 does 11kW continuous and peaks at 30kW for transitory loads like starting heavy equipment.

The most convenient solution where a generator automatically kicks in during a power outage requires an electrician and extra equipment, but there’s also real tradeoffs to having gas lines going to your home.