On reflection, despite the bad/rushed/deus ex machina/weird tentacle thingy ending, Season 1 was obviously better than Season 2 and surprisingly better than Season 3. 3 was color by numbers. It had all the originality of a JJ Abrams script, relied almost entirely on nostalgia, had a convoluted plot that only makes sense to apologists and was exactly what fans wanted.
Apart from from some what I think were a couple of unnecessary character murders, and the last episode, Season 1 is a coherent story, with great new characters.
And as usual a touching death scene must be resolved in the next story by resurrection.Shaxs knows how you feel Q, Data, etc. The best thing would have been to let Picard die at the end of Season 1 and carry on without him. For a show named after him, he sometimes seems to be the least important character, in many ways. Ok, he hugged Crusher Skywalker back to the light side of the force . He did that. And apparently he hugged Q back to life. That man can hug.