As the sibling comment notes, these days 400a residential service is available as an option in many places.

One home actually consuming close to 400a is pretty rare, but it's possible mainly in gas-free builds, if using things like electric tankless water heaters (a bit niche) in addition to multiple EV chargers, a range, dryer, etc.

Maybe a better way to convey that 100kW is “small” is to point out that industrial sites all around us, such as smaller datacenters, are well into the MW range.