What is the realistic, non-science fiction appeal of this?
I do think that will reach diminishing returns at some point. Kessler syndrome is a real thing for long-term higher orbits.
Humans being interplanetary would be an amazing technical tour de force. But relatively speaking, there isn’t much revenue there.
European settlers being on the north american continent would be an amazing technical tour de force. But relatively speaking, there isn't much revenue there.
The Pilgrims starved their first year.
(Sourcing my claim is difficult. I include this reference [1], which says that the Caribbean colonies were more profitable than all the continental colonies together. It doesn't comment on the cost of the war.)
[1] https://courses.lumenlearning.com/suny-ushistory1ay/chapter/...