Except the worst case demand has to be catered for -- overcast horrendous rain in winter with local solar producing near nothing yet local demand (EV, Oven, Heating, Shower) all running.

You don't get a benefit of reducing peak demand from on-building solar, so you can't do with smaller substations.