I can tell you that my W was a WAW, had an affair, planned leaving for months, read books to help her figure out her sitch, and talked to an IC to help her walk out the door.
She was done -- told me no chance to reconcile, get over it, we can be friends down the line. When I told her I was hurting, she told me "I don't give a f@$% how you're feeling"
Now she's back.
Don't give up because you think its hopeless or because "women don't come back". If you decide to quit trying, do it because that is the right decision for you and what you want.
I'm reading "Why Good People Have Affairs". It says there are 17 affair types. If you read the list and try to figure out which one fits your W's sitch, it may present you with some insight.
I have to warn you that the book is written to be sympathetic to the unfaithful partner and that was very hard for me to stomach originally, it made me feel ill. I can read it now because I'm further along the healing path. If you've got the strength for it, it may be helpful.
Accuray
Married 18, Together 20, Now Divorced M: 48, W: 50, D: 18, S: 16, D: 12 Bomb Dropped (EA, D): 7/13/11 Start Reconcile: 8/15/11 Bomb Dropped (EA, D): 5/1/2014 (Divorced) In a New Relationship: 3/2015