There’s a quite long series of novels that follows on from DS9, starting with Avatar books one and two.
Later they intertwine with Next Gen, Voyager, and (briefly) Enterprise continuation novels too.
But that series was wrapped up a couple of years ago after Picard started, because the TV series contradicted the novels, and the publishers wanted to get back into sync.
I really enjoyed following along with the continued adventures of the ds9 crew.
It reminds me of DS9 in that sense. SNW season two seemed to alternate between really dark episodes and really light episodes.