I'm sorry about your lack of close family, OP. That does sound hard. I understand to an extent; while I grew up with a large-ish close family, the older generation has gone, including my parents, and the cousins have drifted away over the years. I have very little in common with them, and we all live really far apart. I also have no partner and no kids, although I do have a brother.
Here's my take: Family is only a good thing when they're a good family with whom you have things in common, personality-wise. Many families aren't like that. I think everyone would love a good, supportive family who gets you, but all too often, that's not reality. We worship family in our society, but actually a lot of bad behaviour and abuse goes on in the institution of the family.
So, like many, you're pining for what you do not have. While understandable, it won't get you anywhere. The only thing you can do is fill your life with other people. I get involved with things and do charity work, and you meet people through that, or other activities.
It's possible to have a really good life when not held back by family ties. When my marriage broke down and my parents died, in one way it was truly terrible to feel so alone, but in another way I felt like I had a blank canvas to design my own life. It was aloneness but it was also freedom. We did have some family issues that were pretty bad at times, and I don't miss that.
Best of luck!