Melora is one of my least favorite episodes of the series. Only a certain third season episode that also focused on a cringe-worthy romance is worse. Coincidently, that episode's title also started with an M. Romance-of-the-week stories were almost never successful for any of the Star Trek series and were, more often than not, flat out embarrassing.
I don't which one was worse: Melora or the cursed M named episode, which I can disclose as Meridian... (shudders). Both were pieces of crapppy (please insert various swear words here) splodge, unworthy of DS9 and following the horrible TNG romance of the week. In TNG it worked when Riker was making out with anything that had hips and a bust, but in DS9 it just failed miserably.
However the worst episode of all DS9 hast to be Rivals
, a season 2 episode. If TheGodBen does indeed give it his lowest rating ever for a DS9 episode he has so far reviewed, then I want a taco bell!