Yeah as far as I can tell everyone had a really complex relationship with him. it doesn't seem like anyone outright hated the man and he could be nice but he could also be full of himself, get dumb ideas that he insisted on going through with, and he could treat his family badly. He kind of reminds me of Homer Simpson and I don't mean that as an insult. I consider Homer Simpson to be one of the most perfect examples of a fictional character we love despite his many flaws because of his lust for life and being likable despite it.
If I could pick one word to describe Gene Roddenberry I think it would be human.
That doesn't change the fact that if he started preaching at me or I had happened to meet him while he was treating his family so poorly that I would not have had the urge to smack him to try and get him to snap out of it, but I don't think I would have hated the man either.
It must be said he did have a vision for Star Trek that he thought for and even when he was very wrong and he seemed to forget what Star trek was about when he started it I could at least respect him for fighting for what he thought was right even if I think he was wrong.