My overall point is that people seem to pick and choose what they like from Berman's era, and dismiss his work as a producer, when in reality he presided over almost everything we think of as televised Trek (with the exception of TOS, obviously)- including DS9. Getting out of the way of a creative can be just as powerful an act as a producer as getting your hands dirty with scripts.
The thing people tend to miss about Berman is that there's a whole lot more to making a television show than the writing, and Berman was the guy in charge of all of it. Usually there are two different types of producer who work in partnership. There are creative producers, who develop the concepts and characters and handle the writing, and logistical producers, who handle the work of turning the scripts into finished productions. The logistical producers are in charge of the casting, design, set and prop construction, makeup, cinematography, music, editing, visual effects, the works.
That, more than the writing, is what Rick Berman was in charge of getting done for 18 years straight. Yes, he did get somewhat involved on the creative side as well -- he co-created the later shows, he co-wrote the story outlines for many of the big 2-parters and event episodes, and he scripted two TNG episodes and was Brannon Braga's regular writing partner on
Enterprise (and only on
Enterprise, despite the myths about "Berman and Braga" as some permanently joined beast). But that was secondary to his main responsibility to the logistical side of the production, the mechanics of executing the ideas. And in that respect, he did a pretty incredible job. The
Star Trek shows he produced had some of the best production values on television, with fantastic casting and acting, nearly feature-quality sets and effects, full orchestral scores at a time when most TV scoring was electronic (although I never shared Berman's fondness for non-thematic atmospheric scoring), etc. Everyone talks about the writing side of Berman's work as if it were the only thing he did, but it was only a sidebar, and it wasn't the thing he did best. The thing he did best was something most people don't even think about, the process of turning scripts into episodes. Even when the writing on ST wasn't great, the production values were just about the best you'd find on television, and Rick Berman was responsible for that.