I’m probably in a minority where I preferred tng to ds9, and I identify ds9 as the “darker grittier trek” that led to the long vacuum of trek. It was extraordinary, but like a lot of outliers, I think it gave the studios the wrong message about what people wanted.
I thought most people love ds9 the most