I think this applies more on the battery side than the solar side. There are certain options for storage that are totally impractical for home use. For example, vanadium redox batteries [1] are so bulky that you probably don't want to put them in expensive residential real estate, but they're pretty cheap and effective.

But a mix of residential solar and utility-managed batteries could be viable; it's not clear to me that the economies of scale for large solar installations are very strong.

[1] https://en.wikipedia.org/wiki/Vanadium_redox_battery