I value a middle ground in terms of the Roddenberry Rule. Too much adherence stifles drama. But it's still a utopian show and you don't want cheap drama based on secrets, misunderstandings, or personal biases.
Conflict should be driven by people who both believe they're right, and both have a point and reason for their beliefs. Both sides should have merit without seeming cheap or forced. That drives some of the best Trek moral quandaries.
Instead of a rule it should be a firm guideline. You can break it, but you need to justify it every time and the reasons need to be worthwhile.
The darker shows like DS9 worked because it came after five years of TNG. And it built to the darkness and conflicted and flawed characters. Trek had earned the right to look behind the gilded shine of utopia.
I don't need cheap, forced CW drama in my Star Trek, with characters at each other's throats and pushed to be at odds with each other for the flimsiest of story reasons. They're the crew of a starship, not attractive twenty-somethings in a hospital setting forming love parallelograms and fighting!