Does anyone know any Hard Sci Fi books about humans surviving without any hospitable worlds?

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.