First two episodes were epic. The third episode was good, but didn't match up with the awesomeness of the first two. The fourth episode was the worst episode of Star Trek produced in the modern era. A few of those middle episodes that followed were bloated and useless. The last 3 episodes were really good, and I enjoyed the finale quite a bit.
So, ultimately, it wasn't too different than S1, except I think the S2 ending was a bit better. I was disappointed that they spent the bulk of the season on Earth of the past. Those are never my favorite kind of Star Trek stories. I really never liked Guinan as a character, and somehow nuGuinan was even worse. The actress who plays all the multiple characters (Soji, Kori, whatever else) is my least-favorite on the show, so it was a bit frustrating to roll my eyes through all her scenes. Seven and Raffi may be the worst, most unnatural feeling, lacking-in-chemistry relationship in all of Star Trek........which is saying A LOT.
I loved Seven of Nine as a character this season. I thought Picard's journey and associated revelations were excellent and very well-handled. Even though it was inconsequential more often than not, I liked Rios's arc this season. I enjoyed the arc around Renee Picard and the Supervisor protecting her (and I really liked that this was a creative way to get Orla Brady more involved in the show). John DeLancie nailed it and was brilliant in every scene he was in. I loved the return of WC as The Traveler.
Overall, I put it a small step below S1, which had a better middle act and not quite as good of an ending. I also enjoyed it more than S4 of DSC. So, I thought it was "pretty good" but not "great" overall.
I will likely re-watch this fall/winter, like I did with S1 of PIC.