Star Trek Guilt and Regrets (Picard) is mostly good for fan service with the old cast. The story on its own is kinda meh. Star trek works best when dealing with one thing per at most double episode with some background story lines. Longer stories just seem to drag on. It also sort of forces you to watch them in order while I prefer to (re)watch random episodes. When Picard was airing on Space Channel they put a TNG episodes featuring Picard right after, that was actually more enjoyable than the new show tbh. It is very well made, but despite it all looking very grand, it feels very small for some reason.
I didn't mind the long story arcs in DS9. However, in between the longer story of the Dominion were plenty of one off episodes.