For me I would say “The Expanse” is a huge one. If there was ever a self made family, the crew of the Rocinante is one of the best. The amount of time they spend together and how they congeal into life long partners and friends in the face of some truly awful events is really inspiring to me.
I love and hate the Expanse because it's entirely believable that we'd finally clear out the bullshit infighting/politics on earth today just to trade for bullshit infighting/politics in space. It's realistic if a bit depressing in such. :-) The actual acting is also pretty great in the show, and the relationship between the crew kinda reminds me of Firefly.
As far as sci-fi shows go, The Orville was also cool this way, if a bit goofy at times. The crew acts like a large family in many ways but with a diversity of cultures/personalities that are used to reflect real societal issues kinda like the old Star Trek series did.
In terms of books… the Spellmonger series has a bunch of characters that aren't all related but have a fairly familial relationship with each other.
If you haven't read the books, I can not recommend them enough. The show is great! But the books are so much deeper and continue the story much further.
I'm further in the books (audiobooks actually) than the show but both are pretty great
They are really solid audiobooks. Jefferson Mayes (I think that's who narrates) really kills it. Except for his pronunciation of Gimbal, that one drives me crazy!
At one point I had a throat infection and it really messed up my voice, so I kinda sounded like Avisarula from that series. You could tell which of my co-workers were fans when I'd slip "and James Holden will probably fuck the whole thing up" into a conversation