leave things more open or unresolved or ambiguous, which is simultaneously dissatisfying and refreshing

Agreed, and it absolutely depends on the episode. Also agree that they sometimes (often?) bit off more than they could chew, but in general they weren’t so disastrous that I didn’t appreciate the effort. I imagine there was a lot of compromise and horse trading on those scripts, and people were probably relieved to get out something as good as they got. I like to imagine the Ferengi episodes were generally the penance exacted from writers who insisted on too much self-respect.