How long would you wait for God to change a person?

I don’t mean this in a self-absorbed manner waiting for God to change my husband, but counselors think my husband is sociopathic. He does not have empathy or emotions other than anger. It means he doesn’t have true compassion and in my opinion, love. He cannot feel guilt or remorse. He tried hard to change and asked God for help though he was not a Christian. He actually had a God experience once and felt the overwhelming love though he didn’t know what to call it since he said he never felt an emotion like that before. Previously he did commit a form of adultery (not sleeping with someone else). My question is how long should I wait? People tell me to stay because God can work miracles and say that if I wait, maybe God will perform a stunning miracle and change his heart. I have waited for years and I’m miserable. I think we are codependent, not in love. I don’t even know how to get out of this relationship anymore. I feel like I would be in a very bad emotional state if we were to get a divorce.;