the likes of Melora bored me to tears. I'd say that's more because I just cannot stand the character...
The only negative response I've had to Melora was the slow-moving "Gemworld" novel duology, but that was the storyline, not the character. I like the actress and her feisty character. Loved how a character originally intended to be a series regular was recycled for a guest appearance.
That episode was when I pretty much tuned out of DS9 for a long time. Couldn't stand the character or the actress, made Nana Visitor look like Meryl Streep.