Very interesting topic. In my opinion it ist very important to have people in your life, which you can openly share your opinions with, without the fear of being rejected or ridiculed.
This to me, would be the requirement for a true friendship. For the past couple of years i've only had one such true friend in my life, and because we life about 100 miles apart, it's difficult to see each other more than once a month.
Colleagues and people to hang out with is, like it's been mentioned before, a good opportunity to just do stuff together, but without having a deep connection. However, to me, it always feels unsatisfying, and i don't get much from these kind of relationships.
As far as romantic relationships go, I know exactly what you mean. Women eventually want to meet the people you hang out with, to see how you react with others who you are close with. Also many women feel drawn to guys who are popular, it's the old story.
If you don't have that many contacts, a lot of women see this as a red flag (i'm talking out of my own experience), which I think makes no sense.
If you're not interested in superficial relationships and rather seek true friendship (which imho is incredibly hard to achieve) that, to me, would be a sign of true integrity. But people who are not into philosophy and self-knowledge can't relate to that.
So I'd imagine, that if you meet a new girl and she's at least open to these ideas, she'd understand and accept you the way you are. It's however also very important how you go about this subject. If you give her the impression of being lonely, and trying to meet people but it just never get's anywhere, then that would be a negative signal for most. If on the other hand you explain that you want true friendship and can tell her what this exactly means to you, then I'm certain you can get over this obstacle in a new relationship. Also nothing in life lasts forever. You could have many friends in your youth, and then almost no one once you get older, or vice versa. There are no guarantees, it's always changing. And in a relationship both partners will change over time (hopefully grow), so if you see the bigger picture, whether or not someone has many friends in the beginning should not matter. I don't think that the "friends-issue" has any effect on your character!
But as always: If a woman/girl is truly interested in you, she should want to be with you either way, friends or no friends