If it were a long term or recurring affair, or frequent cheating, or resulted in a pregnancy or something, I don't care how I found out but I'd want to know.
If it were a one night stand and happened once, and he were truly remorseful and it never happened again, no I would not want to...