Ultimately you will have to answer this for yourself. There's no answer for everyone. One thing that makes it harder for you is you're not asking "how do I get a wife". For many, maybe most, women, if your ultimate goal is not marriage, that's at least a big negative, if not a show stopper.
It's very very possible to have an SO, and still be a miserable shit. The more you try to act in ways that feel phoney to you to find/keep an SO, the more likely it is that you'll end up being one such miserable shit. With the possible added bonus of bringing miserable shit children into the world.
The paradox is, the more you succeed in having a happy life without an SO, the better your chances of ending up in a happy situation with an SO.
Sex workers can, in the obvious way, help you be happy without an SO. The problem is, many/most women will see it as a big negative, if you see sex workers. On the other hand, if you can become a fav regular of sex workers, that's a stepping stone towards being a good SO. Perhaps even with the sex worker. Most of the sex workers I have gotten to know don't rule out dating customers. But you have to be willing to be exclusive with them, even though they are doing sexual stuff on the job. Or replace the income they would loose by quitting.
If you are being your true, best self, and a woman isn't into you, that means you are not into her. It's infantile to get resentful, it means you are expecting her to be something she's not. When people lament that no one wants to date them, it's almost always about them not wanting to date anyone they've met so far. Wanting to date the person you wish somebody was doesn't count as wanting to date them.