what this analysis seems to be telling me is that I don't find it easy to get close to women, and that there isn't a single person who I consider a very close friend who I haven't either slept with or want to sleep with

I'm a bit like that, too. I have been close with people I didn't want to sleep with, but the closeness hasn't lasted.