Funnily enough, I can't remember a time when I was very passionate or felt strongly about an on-screen romance, until now.
In Attached, S07E08 of TNG, Picard and Crusher are left stranded on a planet, where they are, hence the title, literally attached to each other through an implant on the back of their neck, allowing each other to read the other's thoughts.
So finally, we get a story where they are forced to come out and admit how they feel about each other, and instead of it being the beginning of their relationship, Crusher cuts Picard off at the pass, and that’s it.
Look, I'm no kind of "shipper", but this whole show's run, I've been anticipating the Captain and the Doctor becoming a couple. And no, it's not because those two characters were written with that kept in mind, but, I mean, we’re talking about two characters who have oozed chemistry from the minute we saw them together in Encounter at Farpoint. At times, you can stick a match between Sir Patrick Stewart and Gates McFadden and it would light on its own.
But, since TNG is an episodic show with standalone stories, there's no romance. Whether that's through the will of the writers or another fault of "Roddenberry's vision", I think it sucks. How nice would it have been for these two to just say "okay, it's been seven years, you guys have been waiting for it, let's go for it"? Like, I don't even care all that much about the relationship between Riker and Troi (okay fine, fuck you, I do care a little), again, I'm not much of a guy for romance, but this? Yeah, I've been anticipating this one.
In general, the episode has you smiling all the way through.
Until the ending, when I, at least, throw my shoe at the screen.