1.
Carrie and Mr. Big -- Sex and the City
Carrie and Big on Sex and the City when she was with Aidan and he was married to Natasha in Season 3. The episode that comes to mind is "All or Nothing" when the first incident is shown through Carrie's guilt-ridden flashbacks. While I can't condone her actions, Big and Carrie were nothing if not passionate and most of us rooted for them despite our better judgement.
2.
Alison and Noah -- The Affair
It's not called The Affair for nothing. How could we possibly justify any woman cheating on Joshua Jackson's Cole Lockhart? When the two leads so despicable that we want them together to give Cole and Noah's wife Helen a break. Yes, these two deserve each other for reasons other than the lust they share.
3.
Annalise and Nate -- How to Get Away With Murder
These two are hot and heavy. Annalise is herself around Nate, but that's not all good. Her student catches them in the act and she doesn't apologize. Nate's later arrested for her husband's murder. Hey, the sex is good!
4.
Ally and Billy -- Ally McBeal
The most scandalous affair that never was would be Ally McBeal and Billy Thomas. They attended Harvard Law School together, but he left to attend Michigan, breaking her heart. He was the one that got away and a kiss was as scandalous as an affair, ruining her relationship and throwing his marriage a curveball. Billy died in her arms of a brain tumor, envisioning the life he imagined he'd had with Ally.
5.
Dwight and Angela -- The Office
Though Angela agreed to marry Andy, she couldn't help herself when it came to Dwight. News of their affair spread all over the office until everyone knew except poor Andy. Finally, Andy found out and challenged Dwight to a a duel which surprisingly ended with Angela losing both men.
6.
Kara "Starbuck" Thrace and Lee "Apollo" Adama -- Battlestar Galactica
Kara 'Starbuck' Thrace was in a relationship with Anders when she had a one-night stand with fellow pilot (and also attached) Lee 'Apollo' Adama. Frightened by her feelings, she proposed marriage to Anders the next day and an injured Lee soon married Lieutenant Dualla. Later, after a sexually charged boxing match brought up their residual feelings, they started an ill-fated affair. While these friends and lovers could never quite get things right, there was no question that Starbuck and Apollo genuinely loved and respected one another.
7.
Cersei and Jaimie Lannister -- Game of Thrones
It's tough rooting for and against these troubled siblings. At first disgusted by their fate, they've been through enough to wish them both peace by this point. Just not together, please.
8.
Cliff Barnes and Sue Ellen Ewing -- Dallas
When Sue Ellen couldn't stand a minute more of the brutish behavior of her husband, JR, she turned to Cliff for comfort. She even thought her first born might be his for a time.
9.
Will and Emma -- Glee
Glee fans knew from the moment Will and Emma shared their first scene they were meant to be. While they didn't have a sexual affair, aside from a kiss, their emotional connection was off the charts. We all knew it was only a matter of time before Wemma would happen, and if they HAD participated in an affair, few people would have cared.
10.
Emily and Aiden -- Revenge
Emily and Aiden were getting engaged themselves while she was set to marry Daniel. Sure the relationship was mostly fake on her side, but Emily still had Daniel's ring on her finger while she was tussling in the sheets with Aiden.
11.
Gabrielle and John -- Desperate Housewives
When the series premiered, Gaby Solis was having a hot n heavy affair with her 16-year-old lawn boy. Yes, it was downright wrong, but it was also incredibly sexy. Even if we should have looked the other way, we looked straight at them and cheered. Whoops!
12.
Rory and Dean -- Gilmore Girls
Rory's first time was with her first love; it's just too bad he was married to another woman when it happened. Even worse, when she writes a letter to Dean while she's in Europe, the wife finds out, and so does all of Stars Hollow.
13.
David and Mary Margaret -- Once Upon a Time
Even though their Enchanted Forest counterparts were happily married, in Storybrooke, David was married to someone, not Snow. No matter what they did to stay apart, their forgotten past got the better of David and Mary Margaret and the two began an affair while David remained married to Kathryn.
14.
Joan and Roger -- Mad Men
Roger has had a lot of affairs, but what he had with Joan felt special. Their pull was real despite his marriage(s). She got preganant, claimed it was another's, although Roger knows the truth. Still wish they had made it, though
15.
Carrie and Brody -- Homeland
Talk about ridiculous. CIA Agent falls for the married, treasonous spy. Except she's mentally unstable and he's somewhat of a hero after all. Somehow it all worked and they were magical together. Until he was hanging from a crane. Their love lives on through their baby!
16.
Kelly and Dylan -- Beverly Hills, 90210
When Brenda decides to summer in Paris, Dylan and Kelly bond on the beach. Thus began Team Kelly vs Team Brenda and Kelly volleying between Dylan and Brandon. Hey, triangles have never been hotter than they are today.
17.
Margaret Houlihan and Frank Burns -- M*A*S*H
Margaret Houlihan's torrid affair with Frank Burns earned her a nickname of "Hot Lips" and a reputation to match. She repeatedly wished for Frank to leave his wife for her; Frank, for his part, was too much in fear of his wife to ever ask for a divorce.
18.
Michael and Sydney -- Melrose Place
This was great. Dr. Michael Mancini cheated on his wife, Jane, with Kimberly Shaw, whom he then married. But once a cheater, always a cheater, because Kim's sister came to town and Sydney wasn't as whacko as Kim and we all sided with her and her affair with Michael, even if she deserved better than him. Team Sydney!!
19.
President of the Free World and Olivia Pope -- Scandal
Fitz and Olivia are on again off again and what makes them so undeniable is that he's the President. Anything with the ruler of the free world always has more scandal than we can handle. Mellie deserves more, and Olivia can choose Jake, but Fitz pulls at her heart. What to do, what to do??
20.
Oliver and Sara -- Arrow
Ollie's affair with Laurel's little sister led them both to the Queen's Gambit and set into motion a chain of events that led them both to the vigilante life. The Arrow and the Canary brought the heat in the street AND in the sheets. Now, Sara and Ollie's initial indiscretion is water under the bridge, and with Sara's passing, Laurel has taken up the Canary torch in her sister's honor.
21.
Will and Alicia -- The Good Wife
It's hard to even consider this an illicit affair when Alicia's husband had previously slept with some hookers (oh, and Kalinda!), but hey. She was married at the time.
22.
Ray and Kate -- Ray Donovan
Ray always has affairs, but what he shared with reporter Kate McPherson was different. They got each other and he trusted her with too much. So much that it got her killed.
23.
Remy and Jackie -- House of Cards
Jackie and Remy started out casual and gradually fell more deeply in love than they realized. Of course, they both work on the Hill so the odds were never in their favor. Jackie married Alan for love and professional advancement, but neither she nor Remy could shake their passion and they were last scene making out as Remy was about to leave D.C.
24.
Riggins and Lyla -- Friday Night Lights
When Jason Street was paralyzed, it was natural for his girlfriend and bestie to seek comfort with each other, even in each other's arms. Loving them all so much made it impossible to hate them for what they were doing, even though it was heartbreaking.
25.
Tony and Gloria -- The Sopranos
Gloria was like a breath of fresh air in Tony's life. We even kind of liked her in comparison to other affairs. He should have remembered where they met, however, because it didn't take too long before she turned psycho and eventually killed herself. Nothing was quite normal in Tony's life.