Rick Berman was an excellent producer. He supervised an operation that, at its peak, encompassed the simultaneous production of two SFX-heavy weekly TV series and one feature film. The fact that production always moved smoothly along, and that episodes and movies always came out on time and usually under budget, proves that he was very good at that part of his job.
But he had the creative ability of a cheese log.
The best Star Trek produced on Berman's watch happened when someone like Michael Piller or Ira Steven Behr was overseeing the creative side of things. The more involved Berman got creatively, the worse the end result usually was.
Brannon Braga was great at coming up with trippy, high-concept sci-fi ideas. But he sucked at creating and developing characters. If he had a writing partner like Ron Moore to pick up the slack in that area, then all was well. But when his writing "partner" was Rick Berman (and I put the word "partner" in quotes because Berman was actually his boss, so it wasn't exactly a partnership) well, that was a recipe for disaster.
I think what everyone would have preferred was to have a writer-producer with strong creative abilities in Star Trek's drivers' seat.
All that being said, my answer to the question posed by the thread title is: anything that comes out of Richard Arnold's mouth. I really despise that guy.
This.