Hello, I am Rafael. Thanks for asking your question - I'm here to support you. (Information posted here is not private or confidential but public).
I am sorry to know about this s very frustrating situation.
Could you please tell me for how long did you date before living together, what you think has caused these serious issues and what he says about them?
I am sorry but this would be unacceptable for most people in your shoes, as long as it's about adult and committed relationship. This i snot about business relationship on,y, right? Then if that's the case, it does seem much more like he has been using you financially and for work related benefits instead of truly respecting, caring and loving you as a real life partner.
I think you need to reassess very clearly which are your core needs and expectations in this relationship and come to terms with the fact that this person seems to be far away from meeting many or most of them. If that's the case, you would need to rethink how sound it is too stay, if he is this unable and unwilling even to acknowledge the issues, take responsibility for them and work on solutions.
For a relationship to develop and grow as a truly healthy and fulfilling experience, it needs to be mutual, both partners should show respect, honesty, caring , affection, passion, understanding and support to each other, otherwise neglect, abuse and manipulation could become the very core of it, and no matter how much one tries to make it work, if the other ones does not feel and show the same, it would not work.
If this person has almost not have any sexual relationships with you for this long, but uses pornography, this sexual enhancer substances and dating agencies, besides of not being a healthy partner at all, I do not know what could justify you perpetuating a relationship like this. I just hope you have got all the money that you gave to him.
If what you expect is real respect, honesty, affection, passion, a real partner who cares and supports you, who actually shares life with you and more, then I do not see how staying with a person like him who is unable and unwilling to even acknowledge all these serious issues could help you at all.
I am sorry but this does not look good at all, I am sorry but everything you describe here seems to show how poorly and dishonestly this person has been in your relationships, and again, as long as he does not even acknowledge the serious personal issues he has, takes full responsibility for them and chooses to work on himself and the relationship, I do not think your situation would significantly improve at all, but become more dysfunctional and hurtful.
Does it make sense?
This is not only about red flags, but about multiple serious issues at multiple levels, and again, while on one hand it seems you have been giving a lot at every level, this person has been doing the opposite, and when that's the case, it would be unrealistic to believe the relationship would heal and be fine. He does seem to have several issues that may requires professional support for him to effectively work on them, and he is the only one with the power and responsibility to make that happen.