Proverbs 7 is always good to read if one is thinking an affair would be a good thing:
21 With persuasive words she led him astray;
she seduced him with her smooth talk.
22 All at once he followed her
like an ox going to the slaughter,
like a deer[a] stepping into a noose[b]
23 till an arrow pierces his liver,
like a bird darting into a snare,
little knowing it will cost him his life.
That whole chapter in Proverbs is GREAT; and will give one pause. - Also, Joseph RAN from the house where Potiphar’s wife was tempting him; he didn’t linger for a second.