In terms of average usage an average sized home in the US is much closer to 50kWh a day, so roughly 2kW average demand. That would mean 1 MW is enough for 500 homes on average. The one thing that doesn’t is peak demand load, say when everyone gets home from work and turns everything on at the same time or a particularly cold or hot day.
Edit: the average US home uses just shy of 1000 kWh a month, or just over 30 kWh a day.