After "The Ship" episode, where we don't only see the troubles of being captain, but also the cost of a life of a person you know it closely, we have "Looking for Par'Mach in All the Wrong Places."
Basically this episode took two subplot who are similar if you analyze:
In one hand we have Worf dealing by the fact the person he is attracted don't look at him, and decide to give an hand to Quark instead of being jealous, if you trully are interesting in someone, you want to see it happy no matter who is, right?
By other hand, O'Brian and Kira deals with intimacy while Keiko don't care since she is open minded and see Kira as a reflect of herself, after all; Kira carry their offspring as we see some episode ago, Keiko want to see O'Brian treat Kira as her.
Some people complain about the characters acting dumb sometimes, but after all, who don't act dumb at an moment in your life?
This is the good thing of Star Trek series, one episode can be full of action sadness, and another episode can talk about day-to-day topics.