I am actually currently rewatching episodes of season 2, and I have to be honest with myself: this season does not get better on a second watch, in fact: I liked it a lot more the first time around. Knowing where it's all going, it's a very dissatisfying season as a whole. I am almost always extremely positive about Trek, -any Trek!- but this season has lost me on several points.
I really dislike the casting of the same actors in different roles, without explaining it properly, or stretching it really, really beyond belief. Adam Soong for instance... I don't really like that there are now 4 ancestors of Data that look EXACTLY like each other... Also, I don't think Brent Spiner was really into it... His acting was really off imo, expecially in episode 8...
Laris/Talinn just was so awkward as well. Raffi did mention they look just alike, but it's never properly explained (besides hinting at 'ancestory')... And then there's Kore...
Also bugging me is Q's plan... Why was he trying to prevent Reneé from joining the mission..? He was even trying to get her killed... Why..?! Wasn't his ultimate goal to grant Picard closure..? How did killing Reneé factor into that..?! It was never explained either...
There are many things that just didn't work. The battle against the "Borg drone soldiers" lacked scale, the color correction of the daytime LA scenes were too yellow, I could go on and on... The direction and production just wasn't tight enough, and that's probably partly due to COVID restrictions.
All in all, it just never focused story wise. That doesn't mean there weren't things to enjoy!
I really loved the opening episode, The Star Gazer. If only a larger part of the series had taken place in the 24th century... I liked the last episode as well, even though it worries me we won't get an answer as to who created the anomaly this episode ends with... I loved the fact that Guinan, Q and Wesley were in it, as well as the 'Punk on Bus'. And I actually liked the whole 'Picard childhood trauma'-story arc.
Maybe in a few years, I will look at this season differently. I hope so. I am just glad we even got this series, and S3 looks like it will be glorious.