>Use local solar generation, and a lot of batteries. This works well in most of the world, but less so in northern Europe (it's not very sunny).

WHERE???? Nobody gets their electricity this way at any reasonable scale.