It is the nature of extremism to misapply moderate terms, like "conservative" and "liberal" (which, when properly used, aren't mutually exclusive): they label themselves with one, in order to make their extreme point of view appear moderate and reasonable, and then label everybody else with the other, in order to demonize the term, and demonize everybody outside their extreme. This happens because the worst enemy of any extreme point of view is not the opposite extreme, but the center.
But that's veering even more violently off-topic than the tangent about "sitcoms about nice people" as opposed to "sitcoms about assholes."
I've actually already said my on-topic piece here, but to reiterate and summarize:
1: Una McCormack's Last Best Hope is not even remotely the worst by any reasonably objective standard; it is simply too much of a downer, about too utterly hopeless a situation (not even the CODA trilogy was that depressing), for me to ever want to re-read it; that's what the assignment to write a Picard Season 1 prequel novel called for, and she delivered.
2. Jeter's Warped is objectively bad (and my only recollection about his other ST opus is that it wasn't anything to write home about either), but it's not even remotely "the worst."
3. I've never encountered anything worse than M&C's Phoenix books, although when every other Bantam ST title was a variation on "Kirk & co. go mucking about with things they don't understand" some of them, like the ever-popular Devil World, come close. As do M&C's Pocket titles.
*** later ***
4. I probably despise Section 31 books (and episodes) in general even more than I do the "Phoenix" books, but (as with LBH) not because they're intrinsically bad, but simply because I intensely dislike the subject matter. (And the arc leading up to Leland's well-deserved demise particularly, because it manages to combine Section 31 with a particularly nasty "eye-scream.")