I don't know how I would react if my husband ever cheated. I don't think that anyone can know till they go though it.
Right now, IMO, I wouldn't stay. We don't (can't) have children, so there isn't that issue. I know that I could never again be intimate with my husband, so that in it's self...