Just finished all 3 seasons. I'm not a ST purist, I watch each show for its own content. That said, I did enjoy ST:TNG so I already was inclined to like Picard, and was interested in what his followup arc would be.
I found Season 1 to be very good (interesting plot lines), season 2 I found to be nearly unwatchable (I HATE HATE HATE the ancillary character that is the basis of its plot, and tbh I ff'd through half the episodes, and watched the "previous highlights" for most of the others.)
But Season 3 redeemed this show, IMO. Yeah, it had some corny bits, but it was also very satisfying by the final episode (S3E10.)
Season 2 took it from 5, to 4, stars. I would watch S1 and/or S3 again, but not ever S2.