I used to read Star Trek novels in the 90s when TNG was at its peak(ish) and they had some ‘real’ authors writing books. Even some of those were stinkers.

While I’m a huge Stargate fan, I always imagined they would be pretty horrible and full of bad characterization