I just finished watching all 7 seasons of DS9 via streaming Netflix. When the series first came out, I only saw the first 4 seasons or so. Watching each episode without waiting weeks in between gave me a whole new appreciation for the series.
The last scenes were heartbreaking...seeing everyone go through all the flashbacks, it feels like saying goodbye to old friends I'll never see again.
So sad to know there will never be a movie or follow up. I suppose there are some novels out there but it just won't feel the same.
As a person who loves DS9, I say read the novels!!