Picard and Discovery were both pretty awful.

I enjoyed the first season of Academy. It is a bit teen drama for some though, and it picks up in the far future Discovery timeline which means its basically a different continuity from the other series.

SNW is good in spurts, not nearly as bad as Discovery/Picard, but it does have some pretty clunky episodes as well as ones that are pretty great.

As others have said though, Lower Decks is easily the best new(ish) Trek show but it's a love letter to 90s Trek so I wouldn't watch it until you're ready to get the myriad references.

Now I kind of regret not highlighting Academy, because it got off the an very strong start. The first three episodes were okay, and by mid season it was straight up excellent. Sadly it's already cancelled, so we wont get much more of it.