At the end of the day, unfaithfulness is not a question of once or twice but of a pattern of behaviour that can either be changed or not.
Someone who is chronically unfaithful could catch diseases and pass them on to whoever is close to them.
On balance, I would say the price is trust and eventually, the relationship. But maybe that's the price the unfaithful party is willing to pay?