I agree it was enjoyable. While I've actually enjoyed this season so far (a trait sorely lacking in previous seasons), I wouldn't put it on the same level as DS9 or the best of TNG. Then again those shows have 20+ years at their backs, so expecting any series to immediately reach the same level as them is asking a bit much.
And yeah, there's the nostalgia factor. It can easily detract if they go overboard, but I'm willing to cut a little slack if this is going to be the TNG cast's swan song. I'd prefer this over Nemesis being the last we see of this crew.
Still, four more episodes is plenty of time for them to completely f*** it up.