There are already some huge maps out there, Just Cause 2 and 3 both have maps at around 1000km2, and those games are beloved by their players. But if the next Cyberpunk game was announced with Night City now being the size of an actual large metropolis, say like New York, would you say that’s too big? What determines what “too big” is?
On the other hand, the world of Fallout 4 feels very cramped; you can’t go 5 meters without encouraging something. Bethesda’s games are interesting in this aspect – the worlds of different games are built similarly, but they differ in some small parameters (as in the density of Fallout 4), so they’re ripe for comparison.
Personally, I feel there were two peaks in Bethesda’s worlds – Morrowind and Skyrim. Both for different reasons.
As a Morrowind enjoyer, I find Skyrim to be too shallow. There’s 7 weapons in the game, 7 spells, and nothing really to do.