Guess I'm somewhere in the middle, I really liked season 1, despite some minor issues. Data's farewell was so absolutely stellar, imo, that it easily makes up for any other issues I might have with that season.
And I even enjoyed season 2, although I admit that the writing was absolutely terrible from episode 4 or 5 on and they totally messed up the arc. But again, many really great character moments made up for it. Just like I even enjoyed the badly written TNG and especially DS9 episodes, when they at least had witty character interactions or moments, PIC season 2 didn't entirely feel like wasted time, to me. Especially Picard's farewell to Guinan and Q felt very right to me.
So ... season 3 "righting the ship" means for me that they won't waste as many great opportunities as especially in season 2, and manage to not only present wonderful character moments, but also write a good, convincing season arc. Obviously, it's too early to tell, but I liked the first two episodes (they are total nostalgia-begging fan-service, but hey, I'm a fan, so who am I to complain?) and am confident they'll at least get the character moment business right, even if it might turn out they still don't know how to write an arc.