Name changed as its a bit of an embarressing/pathetic question 
I'm not usually one for "types" however I've been noticing a trend recently in the people I attract/don't attract and its troubling me because it honestly feels like I'm stuck and there's no way to change things in the future.
I'm by no means a guy who gets lots of interest from women, however I'm well liked and been told I'm unusually emotionally intelligent for a man (I can't confirm this - only going by what others have said).
More than once, I've got into emotional affair territory - a female friend has made it known to me they have a crush on me, although in all cases when this became apparent we both swiftly reduced contact and no damage was done. In many cases, whilst I was told someone thought I was "cute" it was done with a heavy dose of "of course, I've got a partner who I love and we know our boundaries".
Most of these women have been people who I've clicked with, respect and just enjoyed the company of. There wasn't necessarily an immediate frission. We didn't heavily flirt. There was no "cheeky banter" or whatnot. It was just incredibly easy to chat to each other and were, what I considered, to be friends.
They were people who, if they were single, I'd love to start a relationship with. But here's the problem: I am nothing like the men who they are actually with - and, moreover, that type tends to be the same: decent men, but emotionally withdrawn, somewhat selfish, not particularly curious about life, more traditionally "male" I suppose - the "strong but silent" type.
My dad was a bit like this too - I'm nothing like him in that respect, so I can't even look to relationships in my family for guidance/a template. i love and respect my mum, but again she went for one of those traditionally male guys too.
And then there was my marriage. My ex and I were together for a decade, had kids, etc. When we met it finally felt like I had finally cracked the code: we were friends for a year before we started dating. She was my best friend as well as lover, we clicked, communicated fine. Even when we divorced, she told me it wasn't anything I'd done wrong and was desperate to stay "best friends". It was because she'd fallen in love with someone else and wanted the chance to experience what a relationship wth him might be like. And that guy, the OM, was... a traditionally male type. His ex told me he was emotionally unavailable, tended to sulk rather than discuss things and was selfish in bed. But my ex prefered that because his unreachability meant he was perpetually "mysterious".
All of this is fine. I'm not owed a relationship, I know that. However, I don't know where this leaves me going forward - everyone who I feel I have chemistry with and who proclaims they have some sort of connection with me, inevitably ends up being with someone the complete opposite of me - who completely lack the emotional intelligence that is, allegedly, such a good thing for me to have. I feel like a complete and utter spare part.
I'm not sure what I'm asking really - maybe some insight from female posters to help me clarift things and help me get out of this emotional rut I seem to have got stuck in. 