Hopefully the other pieces get cheap enough to enable some revolution in the wiring side of it. Falling costs enable some acceptable loss of efficiency, so you can blow 100W on unnecessary power conversion and another 100W or whatever on losses due to smaller cabling.

It badly needs to be standardized in a consumer-friendly way...like power-over-ethernet in reverse. Field-installable, hot-pluggable, fool proof connectors. You can get 90W over some variations of network cabling...bump that up a couple sizes so you can handle 400W.

So you buy a bunch of solar panels and some patch cables, and plug those in to a one or more "power switches" on the roof top. Then run a QSFP+ equivalent "power backhaul" down into utility room where you have your "power aggregation switch" which has a bunch of (power)QSFP+ ports and plug batteries in to a few of those. And of course a couple big QSFP28 ports to an inverter to power legacy 120V loads, which maybe someday you don't need any more as household things move to using PoLE (power over large ethernet).