I've recently built house in the USA. Everything is electric. Standard service is 200A. I asked to double it just in case, but haven't exhausted first half yet. Electric company did not have any issues with it.
I also got 10kw gas generator that I can plug into house if there is blackout. It will power essentials like heating, fridge, hot water. And yet I still can roll it into my truck and take it with me on a road trip if needed. It is heavy and loud. But it was something like $1300 from Amazon delivered, so I am not complaining.
Many places in North America use electric for almost everything - heating, cooling, hot water. 240V 100A used to be common (24kW) but people would run up against that limit, so most new houses have been 200A for a while (48kW). I don't know where that person is that a 400A service is the most common, but I've never seen it outside of wasteful mcmansions (4000+ sqft with associated excessive heating and cooling requirements, hot tub, sauna, heated pool, every room gets a 20A breaker or two, etc.)
I installed 400a service on my 1100sqft home. I was getting solar installed, and my panel had to be updated anyway from an old fire-trap Zinsco. I asked the company how much more to do a 400a service and they said $500 more so I went for it planning on eventually being able to charge 2 EV’s at max amperage in the future.
Silicon Valley. However, my understanding is that max is quite simply that: max. I have no idea what you'd actually be able to pull during peak hours. Houses are also coming pretty much standard with electric car hookup stations in the garage, so that's part of it.
7kW sounds low to me, no one around goes under 10kW, with 12-15 being typical. That said I never heard about home connection over 30kW. Power company charges monthly for available power, so no one goes with huge 3phase connection just in case they might need it.
Spain here: everybody around me gets surprised when I say I have 6,5kW installed, they think is crazy high. A quick google search tells me our average is between 3,45kW and 4,6kW.
I also got 10kw gas generator that I can plug into house if there is blackout. It will power essentials like heating, fridge, hot water. And yet I still can roll it into my truck and take it with me on a road trip if needed. It is heavy and loud. But it was something like $1300 from Amazon delivered, so I am not complaining.