They had their moments. One thing I never liked about the show was how afraid the writers would get. They would stumble upon a horrible problem and just magic a solution sitcom style in under an hour. To be fair they did do it a few times. Borg and Picard. Nog and PTSD.