Girl's Behavior

I'm starting to think I can't be myself around women? Am I right?

I'm 32 years old, at the time of this question. The longest I've ever dated anyone was for 2 months. A large majority of the time, on very rare occassions when I actually do go on a date with someone, I either get ghosted or they tell me they're not interested. The lady I dated for 2 months, I'm still friends with today, and that was over 3 years ago, but she told me she didn't feel the magic or the pull with me. She would then go on to date guys who treated her way worse than I did, but she'd be with them longer than she was with me. I feel like I'm a very genuine good person. I believe in fairness, I believe in communication, and honesty. I also don't try to hookup on first date. If a date goes REALLY well, and I can tell she wants it, I'd be down, but I've never had a first date like that in my lifetime. At the time, when she broke up with me, I thought I screwed up, and thought I was too affectionate towards her and that turned her off, but she says that wasn't the case with me. I've heard women prefer the bad boy, since it's more exciting. I can understand wanting to be with someone who has a spine, and who you feel safe with. I can also understand it in a sexual way too. But when you'd rather date someone who moves in with you, doesn't make money for 6 months and takes advantage of you, just because it's "more exciting", that, I don't understand at all. To be fair, that guy she dated after me, and she says she's learned a lot over the last few years and has regrets, but that thought still lingers in my head. I've asked 2 other friends of mine, both male, about this scenario, and they think I should be myself, no matter what. I also have another friend who believes dating is a number's game. I understand if you think I'm insecure after reading all this, and maybe I am, but I've just been having these thoughts lately that I'm the perfect kind of person to be friendzoned, and nothing more than that.
I'm starting to think I can't be myself around women? Am I right?
Post Opinion