OP you sound like massively hard work. I'm not saying your research is wrong, but you simply can't apply that level of textbook analysis to your own human relationships and expect it to work. You're expecting failure from the off. You've educated yourself about red flags, put the books down and concentrate on having fun with men you can be friends with.
Also- frankly- the whole "deep conversations" thing is just plain scary. As a PP said, these things happen organically. That's what makes the knowledge so precious. The gradually unfolding information given up to each other as time goes on- big secrets, little embarrassments. My husband and I were friends for a long time before we realised we were in love, and I'd say developing that deeper knowledge and having those important conversations is an on going process, and one we are ever improving on. It doesn't happen all at once, and nor would I want it to. We have busy lives, frankly if my husband was always sitting around wanting me to ask deep questions about his emotions, nothing would ever get done. I find it more rewarding when that information is volunteered, frankly. Otherwise it feels a little rude and brutal, like you're pulling someone's private thoughts and feelings right out of them, when maybe they'd rather you didn't.
Also- and I know this isn't going to please you, but I'm being honest. You're clearly an extremely intelligent woman, but, emotionally and romantically, I'm getting "protagonist of a Young Adult paranormal romance novel" vibes from you. You want a man who will basically stare into your eyes and spend most of his time talking about Really Important Things and your relationship. In real life, you're almost forty, presumably the men you meet are around the same age. People are mature, they have jobs, hobbies, families. I would hazard a guess that they expect you to be confident and mature enough to state clearly what you want, rather laying some sort of emotional maze for them, one that they don't even know exists, with the Real You as some sort of prize in the centre.
Relax. Stop wrapping yourself in layers, like an onion, and be more open. Have a good time with a wide variety of pleasant men. For all your exceptional men, somehow I doubt you've met anyone who was just nice and uncomplicated - I mean, one of your paragons was an alcoholic? Something about your thinking isn't working. I could spot a problem drinker miles away by the time I was in my mid twenties,and wouldn't have got any closer to begin with. Stop seeing yourself as some sort of prize to be won and focus on making genuine human connections with people, based on warmth and liking