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?
The Merchant Princes series hits that sweet spot between mindless explosion thriller and fascinating essay with some worldbuilding on top, and I wish it was more widely discussed.