'Star Trek' creator Roddenberry apparently died two days after the film was screened. In view of the 'Star Trek V' debacle, I like to think he died a relatively happy man bearing in mind that 'Star Trek VI' is one of the best of the original Star Trek crew films, and in fact, arguably one of the best in the entire series. The only other good 'Star Trek' prior to the reboot was 1996's 'First Contact'.
You could right an entire book on how Roddenberry was full of hypocrisy and BS, and constantly making CYA (cover your ass) moves to deflect criticism and shift blame to others. Wait...someone *did* write that book - a guy by the name of Harlan Ellison!
As much as a "force" as he was for bringing Trek to the small screen, there were some other people out there not only making "his" vision possible, but he was also put in the position of creating a kind of show that looked at problems. And he was asked to do so by people we'll never know.
In short, mister Roddenberry brought Trek to the screen, but it was not solely his idea. And, on top of that, he did play the part of the egotistical sleazy producer. How much of that was actually him, and how much of that was "a cover", I guess we'll never know, but perhaps future generations will.
I really loved the stories and artistry of the show, but he was not the sole creative force, and even the stories he gave to other writers were not his own creation.
And that's how I can safely remain a Trek fan without feeling bad about someone whose character was out of balance.
I think that he was happy with TNG, even if he drove a lot of good people on his staff away from the franchise and frustrated others.
Read Shatner's Star Trek Movie Memories. Roddenberry kept pitching his "Kennedy Assassination" story each time they started pre-production for a new movie. I'm surprised it didn't turn into a TNG episode.