This summary of a YouTube video about him explains it pretty well:
Rick Berman took over showrunning partway through S1 of TNG when Gene Roddenberry's health declined. He only had one real producing credit to his name, and it was for a children's show. Some of the crappy things he did included:
• Being awful to women actors, corroborated by Denise Crosby, Marina Sirtis, Terry Farrell, Jeri Ryan. He gave them zero respect during contract negotiations, increasingly wanted to sexualize their roles (catsuits, "decontamination" scenes, etc), and straight up fired Terry Farrell from DS9 after she just asked for an episode reduction for S7.
• Screwing over Wil Wheaton by forcing him to turn down an opportunity to star in a big movie for no reason other than control/power
• Denying Garrett Wang the opportunity to direct an episode of Voyager, even after a bunch of main Trek actors have directed episodes before
• Attached his own name to the DS9 episode that introduced the Maquis, despite not having anything to do with the episode, because he was afraid Ira Behr would want royalties for VOY (since the Maquis were integral to VOY). Ira had no intention of this, it was Berman being paranoid and having a lack of trust.
• Consciously and continuously steering away from any references to gay people, despite numerous good script pitches and actor pitches. Notably, had completely genuine, organic opportunities to turn Garak and Malcolm Reed gay with full support of the actors, but instead completely steered the other way and put them in situations to "confirm" their straightness.
• A general attitude toward safeness and dialing back any bold actions. DS9 writers basically had to go behind his back to do certain things, and he hated the show as a result
• Also hated the idea of serialized storytelling because he believed all the money was in syndication, where single episodes needed to stand on their own.
• Told the human actors on VOY to intentionally be boring so that the alien actors would seem more realistic. Numerous scenes had to be reshot because the humans seemed too emotional.
• Increasingly stuck his nose in the writing credits for VOY and ENT (even though he wasn't a writer!) as the franchise began to spiral downward. Once he gave showrunning control over to Manny Coto for S4 of ENT, the show became good, although by then it was too late.
Jadzia was easily one of the best parts of DS9. I had no idea her departure was because of a request like this. That's pretty stupid.
Take a fan favorite character and fire her because she asked for a bit of a break? That's completely idiotic. I'm not going to say that Ezri was bad or anything; but the fact is that Jadzia was great and replacing her was entirely the decision of one small man who couldn't give enough respect to his co-workers to respect their wishes all because they were women.
I can only imagine what could have happened, and how great things could have been if this one fool was ejected sooner.
Well, I was thinking that you could just shoot the 2 war criminals, and after that kick some brain damage into Berman’s head… but that would imply brain.