Most relationships are as you describe. Many relationships aren't(I don't know the numbers, but I would guess somewhere between 1% to 10%, either of which I would qualify as many).

It's also extremely different to agree that some amount of extra-marital sex is OK, to being cheated on without being aware. The betrayal of trust is to me the main problem with cheaters.