Apart from Janeway, which admittedly was a massive mistake, the novels have brought more people back than killed them. It's hardly the novels fault that, for example, Riker and Troi aren't on the Enterprise anymore or that Data died.
As already mentioned I don't have any objections to TV timelines set books but inevitably they'll have to be plot focused as there's a limit to what you can do with the characters. It makes complete sense to me that most authors would prefer to work in a living universe rather than one that never changes.
Variety isn't a bad thing bit if all books were set in the TV timeline I doubt I'd still be reading.
Just to clarify, it's not necessarily screen era based books I want. I want books where the characters and set up at least resemble their screen counterparts (the reason why that logo is on the front and I buy the books month after month)
TNG is almost doing that (especially with Titan basically folded in now, look at Prey) and VOY is definitely doing that. DS9 is not doing that except when it jumps through hoops in the standalone books to do it (Miles and Nog go somewhere else, Quark and co have a problem and Odo decides to help investigate. The Quark based books have been the most consistently good, and I don't even like the character that much.)