Hey guys, long time no see!
So thanks to the current pandemic, the wife and I have been re-watching TNG, DS9 and Voyager. We're on the last season of Voyager right now and after having not watched some of these episodes in years, it's very interesting how the quality of Trek waxed and waned over the years. Anyways, watching all this Star Trek recently has encouraged me to look into who exactly was executive producer/showrunner during which seasons, and to what effect that had on quality. All this information is available on wikipedia or memory alpha but given the recent conversation about the later seasons of Voyager, I thought it would interesting to post it here in a nice succinct format for discussion.
Next Generation:
Season 1: Gene Roddenberry
Season 2: Roddenberry, Maurice Hurley
Seasons 3-4: Roddenberry, Rick Berman, Michael Piller
Seasons 5-6: Berman, Piller
Season 7: Berman, Piller, Jeri Taylor
It's worth noting that Roddenberry's direct control was curtailed significantly after the first season due to his declining health and pressure from the studio. Also, while Piller was still given a credit as executive producer and showrunner on season 7, his input was relatively limited as he was mostly focusing on DS9 at the time, hence why Jeri Taylor became an executive producer and showrunner for season 7.
DS9:
Seasons 1-3: Berman, Piller
Seasons 4-7: Berman, Ira Steven Behr
From what I've read or heard in interviews, it seems that Berman overall had very little direct input into DS9 after the first season as he preferred to focus on TNG and Voyager. Also it appears that while Behr was only a writer and episode producer for the first 3 seasons, his role in shaping the overarching story was immense (the creation of the Dominion and subsequent plotlines were largely his doing), and even before Piller left after season 3, Behr was already being groomed as his replacement as showrunner so that Piller could focus more on Voyager. This is probably why I found DS9 to be the most consistent of all the shows in terms of quality, given that so much of it was the product of one guy's creative vision.
Voyager:
Seasons 1-2: Berman, Piller
Seasons 3-4: Berman, Piller, Taylor
Seasons 5-6: Berman, Brannon Braga
Season 7: Berman, Kennith Biller
It's a damn shame that Piller left Trek after season 4 of Voyager as it appeared that the show was just starting to find it's legs with the introduction of Seven of Nine. While most of the episodes that were focused on her and the Borg were pretty consistently good for the remainder of the series, it seems that after Piller left all the other characters just kind of fell by the wayside, perhaps because Berman, Braga and Biller didn't really know what to do with them (other then the Doctor, who is the other highlight of the show). The writing of Janeway fluctuates wildly from one episode to the next (was she by the book like Picard, or more of a risk-taker like Kirk?) while everyone else is just relegated to their niche and forgotten, only to be trotted out for the sake of plot necessity or variety of character focus. Which is a damn shame, as the show is pretty well cast and Kate Mulgrew is an immensely talented actress.
Overall, I've come to the conclusion that much of what made Trek great during that era could be attributed to Piller or (in the case of DS9) Behr. Braga had plenty of experience writing and producing individual episodes for Next Gen and Voyager prior to becoming an executive producer but I just don't think he had the vision for the big picture necessary in a showrunner, and neither did Biller, despite his extensive writing credits for Voyager prior to becoming showrunner for season 7. As for Berman, while he can take credit for presiding over what could be considered the height of the franchise, by most accounts he was more of a studio exec type rather then a creative force, and relied heavily upon the talent of others. Once the creative minds with big ideas like Piller and Behr left Trek, it's no surprise Berman and Braga had difficulties carrying on without them.