Picard was, IMO, not a TV series, but pure fan service. If it hadn't been for Jeri Ryan, it wouldn't have been watchable. The third season was the worst.
SNW was clearly made to not offend anybody. Solidly made, no experiments.
Just the right thing to keep an extremely conservative fan base happy.
Discovery had one (big) flaw:
Unnecessary dialogues!
Except for the episodes directed by Jonathan Frakes, they totally ignored the "Show, don't tell" rule.