Disclaimer: I'm biased in that while I actively dislike Alex Kurtzman 1000X more than anyone involved in the TNG to ENT production run, I'm a big Terry Matalas fan, to the point I wouldn't have watched season 2, let alone signed up for a month of Paramount Plus, if he wasn't involved with this season.
Terry Matalas and Akiva Goldsman were co-showrunners for season 2, with Goldsman outranking Matalas in the credits. They most likely developed the episode to episode outline for the season together. Matalas posted on Twitter that he was basically out after episode 5 to work on the third season, where he'll be the sole showrunner (and seems to have a greater hand in production and post-production, to the point he'll have directing credits on some episodes, and brought in an editor and music composer he worked with on 12 Monkeys).
Matalas' strongest influence was likely in the first three episodes of the season. So, hopefully a good sign for you.
Cindy Appel worked on MacGyver season 4 with Matalas, and she wrote or co-wrote episodes 5, 6, and 8. 5 and 8 had some pretty decent moments. I'd argue episodes 4, 6, and 7 were the weakest episodes, and those were written or co-written by Jane Maggs, who dropped into the production credits at mid season. My hypothesis for the weakest link in the season anyway.
Interestingly enough, the season 2 finale writing credits read "Written by Christopher Monfette and Akiva Goldsman". Whenever you have an "and" and not an "&", that means someone came in and rewrote someone else's script. Monfette was on 12 Monkeys and a short lived SyFy show with Matalas. Based on the credits, it's highly likely he was heavily rewritten by Goldsman (and Goldsman infamously rewrote Bryan Fuller's script for the first episode of Discovery, so not a great track record). So even the finale can't serve as a baseline for season 3.