It seems to me the single family dwelling, or at least single location power generation is much more feasible. Even if you just cut your publicly supplied energy consumption in half, you’ve accomplished quite a bit.
_______________
Since private personal energy use is such a pittance of the grid, I cannot see that it is very helpful.
Here in Southern California we are at the breaking point on power supply. If as you say the SFD is a pittance, even if it amounted to 10 or 20%, that would ease the pressure on the grid so there wouldn’t have to be rolling blackouts and the like.
They simply refuse to build new infrastructure, as if keeping the power off during the day is going to resolve problems in the long run.