I’m looking to get inspiration for my own writing. I need a hard sci fi series where earth (and earthlike worlds) are too rare, inaccessible, and/or previously spoiled beyond ability to sustain life. Bonus points if it is set on a multi-generational space station or starship without any other options and goes into detail about life support, living space, mineral mining and expansion of the station to accomodate a growing population, and daily life of it’s residents.
If anyone remembers Drifter Colonies from Titan A.E., that’s what’s in my head.
I’m looking for The Martian levels of realism, and I’m fine with a bit of “Unobtanium” clichés if they’re not core to the story.
Not quite what you’re after but I absolutely love Diaspora by Greg Egan.
It’s a different take on the same issues you’re asking about (not at first, but it’s not really a spoiler to say that it explores them whether or not it’s as necessary as your examples state), a take that leans more into different forms of existence rather than supporting our current existence in a different environment (but touches on aspects of that too, kind of). It’s mega-multi-generational while also not being that at all, depending on perspective.