Modern Trek lost its way years ago.
Of course my opinion is very skewed since I was 14 when TOS began ....
TNG seemed to suck deeply, but a rewatching in the pandemic made it less horrible. My big problem was that I despised most of the major characters. If 2/3 of the shows were discarded it could have had a few excellent seasons.
I kind of liked Voyager even though it was goofy and lame. DS9 was hopelessly tainted by awful characters and acting, although it was pretty well written. Discovery has had some excellent moments but mostly flounders in ludicrous improbabilty and implausible writing.
Enterprise and Strange New Worlds are by far the strongest of the later series, in my opinion, although there were very weak episodes in them. I struggle to excuse the liberties that they take with canon.
Picard does not deserve honorable mention, mainly because I never liked Picard due to the gigantic stick that was always up his butt. In my opinion each entire season could have (and should have) been edited down to a single excellent episode.