Solar can be an excellent adjunct to a complete energy generation system, and I question the assumption that it needs to be off grid to be useful.
Run the solar panels and sell excess energy to the utility all day and then buy it back overnight.
Or, buy a natural gas powered cogeneration plant that features an integrated heat pump; the heat warms your home, the natural gas turns a generator for electricity which then powers your home.
OR, buy a fuel cell and it does the same thing with higher efficiency. Even then, solar could help during the day.
If you're concerned about battery storage, consider an electric car; they are glorified rolling batteries, after all! Once the battery is full, driving is much cheaper than gasoline and if your home grid needs extra juice overnight it could pull it from the car.
IMPORTANT DISCLAIMER;
EVERY ONE of the solutions outlined above are in use today and not stuck in the realm of theoretical or pipe dream tech.