I appreciate Roddenberry's vision, except for the "no conflict" policy that TNG was shackled with. The old truism is "conflict equals drama," therefore no conflict means no drama, or, at least, weak, limited conflict between characters. Thankfully, DS9 wasn't constrained this way. "In The Pale Moonlight" has deep, rich conflict that challenges Sisko as a character, making for great drama. The episode deserves all the kudos it gets.
I know TNG gets criticized for that a lot, but I thought the show actually made that idea work pretty well. The fact this was a crew of mature and professional officers who all respected and worked well together was a huge part of it's appeal,
I think. And I wouldn't want them to be any other way.
If there was a problem with certain episodes, it was because of generally bad writing or a boring plot, not because of a lack of character conflict-- because there were certainly enough fantastic episodes that worked just fine without it.