I posted this on Reddit a while ago and it sparked some really good discussion and recommendations.
I really like The Expanse - as it doesn’t just discuss the attempted terraforming of Mars and the colonisation of the Main Asteroid Belt but also
spoiler
the way that these communities decline when abundant habitable planets are discovered, where life is much easier.
So yeah, what are your best examples?
A note on this: the series is written under the Jack Campbell pseudonym. Took me a while to find. The first book is Dauntless