In this new era, I find that I unexpectedly like Lower Decks best of all, because it feels like a Star Trek show to me. It feels coherent with what came before in a way that DSC, with it's redesign of pretty much everything just doesn't. Same reason why I like The Mandalorian, because it fits in nicely with the established universe. I find that DSC requires a massive suspension of disbelief to make things work, what with the spore drive, the red angel suit et.al and I wish they'd hire and actually listen to a Scientific Consultant.
I was properly looking forward to Picard, but the whole thing felt naff to me. From the awful makeup / CG de-aging of Brent Spiner, to the whole concept of cloning Data from a single positron. And then there were the magic plot devices, from being able to see into the past to thinking a tool into existence that once again forces the viewer to suspend their disbelief. Having said that, there were some good moments, and I particularly enjoyed Nepenthe.
I don't think we've had a classic episode from DSC, Picard or even Lower Decks yet. For me, DSC's 'New Eden' would come the closest.