It had a lot of great character moments. The scene between Picard and Ro gave me closure I didn't even know I needed. But then they just killed her off, which brings up a whole other complaint about this show and legacy characters.
A big problem was that the story wasn't being driven by the characters, the characters were being driven by the story -- the above mentioned dot connecting and coloring by numbers. The story they contrived to explain Jack's existence is a perfect example. Crusher had to act totally out of character to have kept Picard in the dark for as long as she did. In the main story itself, Crusher was Crusher, but the backstory that they created was totally story driven and not character driven. And there just wasn't enough story there to justify it.
In the end, the chemistry that these characters and actors have between them is what saved Picard season 3. Even some truly bad episodes of TNG are almost redeemed simply through the poker scenes.