I think most of the problems with the characters had to do with the fact that people high up in the food chain were at odds with the staff writers. I know Maurice Hurley screwed over Tracey Torme's original script for The Royale and IIRC he blocked the writer for The Arsenal of Freedom from establishing a Picard/Crusher romance. In fact, his only good contribution that I know of is helping create the Borg.