Well, in the timeframe of the DS9-R, perhaps that can work, but when you get to the Totality trilogy and the post-NEM novels, the discrepancies become insurmountable. In the Shatnerverse, Bajor still hasn't joined the UFP as of 2378; the starship Titan doesn't finish its relief work at Romulus and make its first new alien contact until a year later than it does in the TTN novel series; and Kathryn Janeway is still alive in 2381.
Yes, this is the 'mental gymnastics' I was referring to earlier. For example, 'Federation' is one of my fav. Trek novels, and it is utterly, utterly inconsistent with
First Contact and
Enterprise. They totally don't work together. Yet, somehow, I beat them into shape together and they both took place in the same continuity, for me. The first trick is to not remember, take note or, or really be aware of dates or stardates in any kind of specific form. 2381 does not mean a lot to me. Was that after TNG? I don't know. It's all 23-something to me. This makes it a lot easier to fudge stuff together. The second trick is to assume that all sources are from an unreliable narrator. This is the trick Neil Gaiman uses when he's watching Doctor Who. We're not ACTUALLY seeing Gallifrey! We're seeing a
vision of Gallifrey, an interpretation, for our eyes. It's like Kirk said in 'The Cage': They were seeing images that
couldn't be real. A camera didn't take them. They were an... interpretation. This sort of mindset is something a lot of Trek fans have to do by instinct. Was that alien really just a dog with a horn on it's head?
If Earth was nearly destroyed by the Borg, chances are that would be pretty big news on DS9. People probably talked about it quite a bit. As it happens, we only saw one brief line mention it in DS9, the show. That's fair enough, we only see 44 minutes out of their day. Likewise with a book. Shifting timelines in your head is pretty easy in comparison with direct contradictions.