Sad to hear. Personally, although I grew up on TNG and still adore all of it to this day, in recent years I find myself far more interested in re-watching the two seasons he produced than the later seasons helmed by Piller. There's something unique and different about those first two TNG years that none of the other modern Trek captured.
I know that there were issues with him behind the scenes, particularly with regards to Gates McFadden, and I can't speak to anything about the man personally. But professionally, I think he was a great asset to Trek.
RIP, Mr. Hurley.