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.
All of Octavia Butler’s books. Not that all the stories are uplifting tales, not by a long shot. But the perspectives of the characters are rooted in family, she explores the ideas of family a lot.