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?
I’ll have to return the favor now. I hope you haven’t read Cage of Souls by Adrian Tchaikovsky. It’s sci-fi, but the characters don’t know that. It’s like a fantasy story to them, but not the reader. They live on an aging earth, where human society has forgotten most knowledge.