I too am in awe of how you are dealing with all of this Lou.
Many years ago, this exact same thing happened to me. I came home from work, at lunchtime, and half my home seemed to have been removed. I also had two DCs that I had to collect from school within a matter of hours. I still shed tears to this day, remembering sitting in my car, watching my little one walking across the playgound towards me, swinging his pump bag, and humming to himself. So, you wont hear me saying that its the worst thing Ive read on here, because I`ve lived it. It was the single, most cruel thing that anyone has ever done to me and mine, but we did eventually get through it. I met the wonderful man who became the husband and father that we deserved. My DC are healthy, happy, high flying adults, although sadly we lost this special man a few years ago.
You appear to be saying that you could accept a one night stand, given the state of your marriage. I could undertand that if that was all it was. However, this man has gone way beyond possible infidelity. He has humiliated you in the most vicious way imaginable. Caused you indescribable pain, and all because he may be guilt ridden. A few well chosen words, and a bunch of flowers is never going to erase what you felt when you walked into your home, the home that he had ripped the heart out of. Like so many of the others, I am amazed at how you are holding it all together. I too was one of the "Please come back, I love you", when, in actual fact what I was really conveying was "Please come back, and continue to crap all over me". Hang onto your amazing strength, and take your time to decide if you want to risk the possibility of being put in this hideous position again, the next time he does something he can`t live with.