I ponder why I'm delighting in your stance. If I'm honest, a big part of this is a two fingered gesture to the slimy gits who think they can 'get away with it'
However is it the right thing for you? I do question this because I feel responsible for encouraging you if it isn't
I can only talk about my experience which is that our relationship never recovered He was remorseful but somehow it became about me protecting him from having to be upset by this remorse?? I was hurting, humiliated (it was a mum at school that I saw daily) and soldiered on hiding my feelings. It led to depression then it led to abuse. I never forgot the shock, horror and sheer fear of being alone and so I got into a mentality of trying to please/keep him. Not consciously. But it happened. Hence the abuse started... because frankly I made it easy.
We had counselling. He was remorseful. All the right things. But we never recovered and my self esteem was eroded. I was very unhappy for many years after.
Whereas now... I feel confident. I know I look attractive. I know I'm intelligent, funny and good company. also possibly deluded but hey I'm happy I also don't need a man so tbh I feel in a very good place. Life still has its challenges. Work is v stressful at the moment. I do 8 hr days, come home and sort DD out then whilst she does homework/plays on the Kindle, I settle down to work. 3 hours tonight so 11 hr day all in all. I think I'm 'lucky' to be able to work at home with her. But I'm a little tired... My job is a good job mostly, varied and rewarding. Right now I'm juggling staff absence and covering too many other people! (I'm getting overtime so not all bad)
Would I accept an affair ever again. Fuck no! I really am worth more and any guy who doesn't realise that would get kicked to the kerb.
So how could I advise you, encourage you any differently.