It depends. From reading random biographies and quotes of famous people, it seems to me that the people we (as a society) most admire were the ones who had success in things bigger than just their relationships. Yes, they often regret screwing up the latter, but then again people tend to regret the things they didn't get right. People who had successful family life tend to regret missed opportunities, etc.
That perspective may change in me as I grow older, and it's probably also a product of my particular upbringing, but looking into myself now I feel like I would be disappointed with life focused on finding True Love, starting a family and dying a grandfather. It feels so... empty. Focusing just on yourself, on your family, when there are billions of people all around you, the whole humanity on this great planet. A grand possible future and so many problems on the road to it.
I know I would like to die knowing I helped everyone as much as I could, that my life had a positive impact on the development of human race. True Love would be a cool addition to that. And I would also like to see space at least once. But more than happy family life I would like to die knowing that some strangers, who don't even know me, are happier because I was here.