I'm glad you enjoyed season 2. I did, too, but that was mostly for the partial return to episodic adventures and Pike/#1/Young Spock. Pike was the best thing about season 2. Season 3 looks just like Gene Roddenberry's Andromeda. The producers have no idea what they want to do with the show.
I cared about the characters in previous Trek incarnations. I think they were well fleshed out, especially DS9's characters. Of course, I also preferred the first few seasons of the original CSI where it was mostly just about the quirky, competent CSIs working cases and not their overwrought backstories and home lives. I can know who a character is and what they're about without needless, over the top drama. I don't care about Michael or her family drama. I don't care about Ash or Tilly or the android they killed off without ever making the audience really know her. I'm far more invested in Saru. That's one person. Hell, I'd rather see more of Jet Reno than any of the others: she was a quirky, fun character who was damn good at her job. And I'd dump all of them like a phaser-cooked hot potato for a Pike/#1/Young Spock show. The problem with today's entertainment is believing every character has to fail horribly and be broken and tragic and dark to be 'realistic'. What BS.
As for Picard, at least the characters are working from broken toward healing as the season closes. I'm really happy about that. Rios being tied to the Cylons is a huge narrative stretch but him finding meaning to his suffering was pleasing. Raffi working to get over her addiction is great. Agnes taking steps to correct her mistakes. I'm very happy with the show right now. I hope they stick the landing.