^ That's the same stuff that Berman-haters have loved to spout for years, encouraged in part by comments by people who Berman wouldn't let run wild over Star Trek, like Ron Moore.
To suggest, as you do and has others have done, that Berman was the executive producer and final authority for all of those years, but that he was not responsible for ANYTHING good that happened and was responsible for EVERYTHING bad that happened is absurd.
First off, Piller, Behr, and others that fans idolize so much could not have done anything without the consent of Rick Berman. He was involved in every aspect of the production of the shows. He was the one who selected those producers, in fact, which is one of the responsibilities of the guy running the show.
Second, your statements about TNG are a little off. Berman was not the guy in charge for seasons 1 or 2. That was Gene Roddenberry. His health had not failed yet and he was firmly in place as the commander-in-chief. The battles he had with writers, producers, designers, and so forth were legendary. It was he, not Berman, who caused the revolving door of creative staff during the first two years. And it was under his tenure, not Berman's, that TNG, if not outright sucking, at least was achieving nowhere near its potential. It was only when Berman became firmly in charge around season 3, and with him a different creative team working under him, that TNG started to become what we all love. Did Roddenberry make some decisions that I preferred to Berman? Sure. I prefer Roddenberry's take on the music, for example. But, by and large, TNG was a hell of a lot better once Berman took over.
Third, I don't buy this nonsense that some involved with DS9's production have tried to put out that suggests that Rick Berman was just involved enough with DS9 to put the lid on lots of good ideas that could have been, but wasn't involved enough to ever contribute anything good. Again, that's ridiculous. Berman was involved in every major decision involving DS9 from the beginning through the end. In fact, he caught alot of the flack from the studio over things they were doing on that show and protected the show from it. Were it not for Berman's influence and credibility coming off of the years of successful Trek he had produced, DS9 would probably not have gotten away with the war arc, for example.
Did Trek begin to wane under Berman's Voyager and Enterprise tenure? Sure. But as others have pointed out, (1) it's very reasonable for someone in charge of a franchise like that to suffer burn-out after many years and (2) once UPN was involved they managed to put a stop to every potentially different or unique thing Berman wanted to do. He argued against bringing Enterprise out so quickly, but they insisted. He wanted to do something different with the first season of Enterprise, but they refused. Etc.
In short, Berman made both good decisions and bad decisions during his tenure with Star Trek, and he produced some classics and some crap. But he managed to keep Trek alive and kicking through four series, four movies, and ~15-18 years (depending on when you consider him starting). And he was in charge for some of the most loved and widely praised Trek. To blanketly characterize him as responsible for all that is bad with Trek is unfair and unjustified.