[quote name='David85']By the time he died, which was the third season (1991) he had less control. Berman did a fine job with help for more than 10 years. You really should blame Braga and Paramont for destroying it. He dumbed it down and added pointless sex while the company didn't give a damn.[/quote]
Roddenberry was responsible for a lot of good things and a lot of bad things. He had a pretty good sense of where to take Star Trek, but some of his ideas just didn't translate well. You can blame Roddenberry for Wesley Crusher and for the no-conflict-among-cast-members rule, which is something that curses Star Trek to this day.
Berman and Braga are more or less a team. They're responsible for some good things, but they're largely responsible for where Star Trek is today. Which is not good.
They continued Roddenberry's "no-conflict" rule, which is one reason why Voyager was doomed from the start. They are also responsible for some of the most destructive story techniques ever seen on television, including but not limited to such Star Trek cliches as The Reset Button (where everything that occurred is magically wiped away by the next episode), DNA-Magic,
Technobabble Takes Over The Ship, What Shuttle Locks?, and Anomaly Follies (where spatial/temporal anomalies get more development than cast members).
The Best of Both Worlds is case in point. They deserve credit for taking TNG to that point and for creating a really interesting cliffhanger. But The Best of Both Worlds II wasn't that good. It resolved the plot, but dropped all the really interesting stuff. Shelby, Riker's antagonist, disappears and his career is all but forgotten. Picard is magically saved by a means that was previously established to kill Borg. The Enterprise magically survives the big badass alien (Trek Cliche #42: The Emasculated Enemy -- create a big bad alien, and slowly chip away at them whenever you need to save the plot). And, at the end of it all, everything is back to where it was.
I don't want to bag on it too much, because it contained a lot of firsts for modern Trek. A storyline that built up over a season. The idea that major events should last beyond one episode. Things like Picard's Borgification actually being remembered, and used in the future.
But these things are only remarkable because Trek simply ignored them before, and treated them half-heartedly afterwards. Voyager was particularly egregious, not even bothering to keep track of how far away from Earth they were. The Best of Both Worlds changed things, but it also set a pretty low standard and Trek has yet to evolve from it.
Oh yeah, I forgot a destructive story device: write a cliffhanger, but only write one half at a time, so when the second half comes around, it is a letdown. They did this over, and over, and over. Never learning from their mistakes. Kind of like their series.
Note that DS9, which looks better with age, is the exception to most of these problems and the show that had their influence the least.
Sex isn't the problem with Star Trek -- the adolescent and smarmy approach to sex on Star Trek is the problem. It's like the episodes that have sexual content were written by the unexperienced teenage nerds that Paramount thinks is their prime audience. And include buckets of hot oil.
But what do you expect from a franchise that just doesn't seem to get humans. Star Trek largely survives on the strength of its captains and its aliens-who-want-to-be-human figures. When it works (Picard/Data or Sisko/Odo) it works great. When there's a weak link, it kind of falls apart, and all you have is a bunch of bland humans.