Can't say I care about the man's sex life one way or the other, everybody has their demons and society's obsession with celebrity's sex lives is trivial and warped. He produced Seasons 18, 25 and 26 which are three of my favourites so he'll always be somebody I admire. Under him the show took a harder science-fiction edge which is preferable to the light, celebrity-orientated entertainment under RTD.
I'm a fan of the later McCoy era too, but I think that owes more to Andrew Cartmel than JNT, and while I can enjoy most of the Davison era I think overall he did far more harm than good, with some truly baffling
creative decisions (I'm with RTD in calling Colin Baker's coat “the greatest mistake in the history of television”). To be fair though, he'd wanted to move on for many years before '89, while Colin Baker had wanted to stay for many years, so naturally the Beeb sacked Colin and kept JNT.