That TNG 'continuing mission' book is not without a few flaws, but it is pretty frank about a lot of what was going on & going wrong behind the scenes in early TNG. Worth a read, to be sure, and that's coming from somebody who wasn't even much of a fan of the show.
All I know about Hurley is that he is notorious for introducing the Borg and harassing Gates McFadden till she got fired. Thankfully, McFadden was able to come back after Hurley left.
How was Gene Roddenberry in terms of his treatment of women?