Picard was inversely interesting to the degree it became S8 of TNG.
As for a future Trek series or movie, my personal preference would be the Year One project as a series and/or a fourth Kelvinverse movie—but that’s because I like the two crews and selfishly want more of each. Of course, I have no say in this, so I will simply do what I have done with all the iterations of Trek—tune in to see what’s on offer and then decide if I like it (I know…a radical approach).
My favourite characters are from the TOS crew (Kirk and Spock chief among them), so I’ll always be more amenable to seeing more of them than any other set of characters, though I will give whatever they come up with a chance. I’d do the same with a series/movie focused on Felix Leiter, even if I’d rather see one focused on James Bond.
Most importantly, for Trek and everything else, I want to be entertained. Here’s hoping for that.