Why is it that strategy games maps either too big or too small?

Take Total War 2...the map size being, the size of Europe.

Then there's Stellaris where you can basically have a galaxy...it's weird :/