Trek improved twice when Roddenberry took a step back. First, it was the movies after The Motion Picture, and then it was TNG after season 2.
He set things up nicely, but the restrictions hurt its future. Once writers could write without Roddenberry's "box", the show was better able to connect with the audience.
My favorite Trek is DS9, which is just about as anti-Roddenberry as you can get.