I'm very sorry to hear of your situation, but what was your relationship like before you found out? You say that you've been together a lifetime, and that he was meeting up with different women since late last year. I'm sure you realise these encounters weren't his first rodeo. Everything you say about him and his behaviour point to him being a seasoned long-term cheater.
Found out he was cheating and confronted him.
How did you find out, and what does confront
actually mean? Did you just have a meltdown, hoping that he would confess everything?
Three weeks later he is just pretending like nothing happened.
That's because you played all your cards and he could see that you don't have the backbone to actually call his bluff. Sorry, I know this is tough to hear, but you know it's true.
All I can think off is ways to cause harm to him.
Understandable but unhelpful. Revenge is a dish best served cold... For now, focus on looking after your own interests.
I can’t stop myself from snooping.
What have you actually found, and does he know - in which case he'll be busy covering his tracks. More importantly, what else do you actually need to know to decide what to do? Trust, once broken, is difficult to restore, and he is not doing anything to try and mend what he has broken.
I’ve really struggled with his ability to be charming and kind and then let me ‘make’ all the steps to move forward on our situation.
He can see that you are weak. He is just sitting back and waiting for your fury to evaporate. He is letting you make all the steps because he can sense that you don't have the gumption to leave him.
He smiles when he talk to me now and tries to reconnect through memories
Typical hoovering technique. Don't fall for it.
I've been there, done that, so I understand perfectly how overwhelming this is, and how powerless you feel. Can you tell us more about the dynamics of your relationship with you husband. Also, do you work, do you have joint assets, could you make it on your own or are you dependent on him?
You need to take your power back. Don't let him gaslight you. Stop his charm offensive right in its tracks. Don't do the pick-me dance. You don't need to make a decision right now, but don't let him have his cake and eat it. Chumplady will help.
Counselling will also help you, but it absolutely has to be on your own. He would simply use joint counselling as an opportunity to vent about everything that was wrong
in your marriage and justify his cheating. Here are a couple of books that you'll find useful:
Six Pillars Of Self-Esteem by Nathaniel Branden
When to Say Yes, How to Say No To Take Control of Your Life by Henry Cloud and John Townsend (ignore the bible stuff - the advice is solid)
You can do this.
“The key is in learning how to live a healthy, satisfying, and serene life without being dependent on another person for happiness.”
― Robin Norwood, Women Who Love Too Much