Ok so he doesn’t drink to the point of being drunk. That’s good.

But regardless how much he drinks, you said you aren’t happy with him and he shares all deal breakers of your ex plus takes it to another level. Bottom line he is not Mr. Right either.

It’s your life of course and you can keep going for these wrong partners. But I recommend to find a good therapist and work on breaking a pattern of going for these men (attraction to these men likely stems from your family of origin and it’s hard to break this pattern but you can do it).

I think time will be better spent on trying to break this cycle rather than trying to get ex partners to come back to you or trying to change them. It’s a waste of your mental energy.