Yeah, in a sense we've been spoiled by almost 20 years of continuous stories. Avatar of course for DS9, Homecoming for Voyager, The Good that Men Do for Enterprise, or was it Last Full Measure. I get the two mixed up.
TNG is harder to pin down. I generally consider Vornholt's Genesis Wave books as the unofficial beginning of TNG relaunch (though it was prior to Nemesis) because that seems to be the start of when TNG books started their continuity run (and they referred to his previous Gemworld books but there's no straight continuity between Gemworld and Genesis Wave that I could discern).
That's also probably the reason it will be harder to give up, since it's been such a long run. For TNG novels, there's only a handful of characters left from the actual show and movies. And how about DS9. There's even less left there, on the station at least. And many of the litverse characters have been with us for so long that they've become almost as important as the on screen characters. I credit the various authors for making those characters important. And I also give the writers credit for working together. When you think about TNG and DS9 in particular, that have had numerous authors, it's pretty impressive that they've all kept the same continuity, and build off of each others work.
And they should all take a certain pride that a lot of us here care enough about the litverse they created that we hope, no matter how unlikely, that their work is somehow preserved in the next TNG show.