I found Discovery the same way, it’s the only trek series I couldn’t make it through.

Picard suffered from bad writing unfortunately. Season 3 cashed in on nostalgia and I appreciate it for that, but the first 2 seasons were very meh.

Starfleet academy is great though, IF you’re ok with a show targeted to young adults. If you’re not ok with that, the episodes will be very hit and miss. The most recent episode was fantastic, once you get through the 3 minute long sex scene it opened with. Even that does serve a purpose though to show the bond that’s developed between two chars.