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.
Adrian Tchaikovsky’s The Final Architecture -trilogy’s one main theme is this meeting of people due to circumstances and growing into a made-family, with the good and the bad that such units entail. All in all its a fun space opera trilogy.
I love pretty much all of his books but this trilogy was truly epic.