Rick Berman produced multiple series that were on budget, on time, and for the most part were highly acclaimed. His movie record was not as good, but he had a very successful run. We have to realize that many of his decisions were not his, as he had directive from Paramount and later on, unfortunately, UPN, that he had to abide by. He allowed cast members to direct, and for the most part we've rarely heard of any "toxic work environ" complaints. When TNG began, Berman was saddled with Roddenberry's ridiculously narrow "vision of the future." He expanded that, and good grief can you imagine if Maurice Hurley had been the "guy" instead? Trek would have been dead 30 years ago. Berman saw the potential in Michael Piller and Jeri Taylor.
Now perhaps his views on LGBT stories, and his preference for certain women's costuming were old hat, but that's just how TV was done in the 90s. He did have an overwhelming interest in killing characters off in movies, but for the most part Berman was great at keeping the ship on course.