I have fucked a few married/cohabitating women, none of them one night stands, they were friends or acquaintances. I knew all the husbands. Only one husband knew because he was there with us the first time, second time it was just her and I.
So, any husbands discover 'later' and get turned on to the idea that you were doing their wife. I do know one wife who confessed to her hubby and THAT turned HER on. Check my stories; I write about mature women fooling around