As far as Discovery and forward go, I’d honestly recommend order of release. I’m not going to feed you any “don’t watch this, do watch that”, I just want to say that various bits of lore are introduced in some series, are then referenced in later episodes of other series. All of the series are making references to each other now. So, I think you get the most of the lore references, if you watch them in release order.

That said, it probably doesn’t really matter – Most of the recent series are in distinctly different places and/or times. Discovery and SNW are the closest (to start) in time and space, and Discovery S2 directly feeds to SNW. Prodigy and Lower Decks are in a similar time space, but very far apart in the galaxy, and Picard starts the farthest ahead in the timeline, though Discovery will overtake it, and Picard also has flashbacks that take place probably close to the time of Lower Decks or Prodigy.

Soooooooooo… overall, probably doesn’t matter, but in my opinion, you get the most benefit of lore knowledge in release order.