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.)

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.

Is that single phase or 3 phase? Most homes in the US have somewhere in the range of 100-200A single phase hookup.