I'm being harsh because you didn't come into this saying "I don't get why I don't like science fiction, somebody help me out here" you came into this saying "Star Trek sucks, fight me." You literally held DS9 to be worse than Brooklyn 99. And your justification is "the writing sucks and the writers suck."

You're not wrong. The bar is generally lower for science fiction. Much like a certain segment of the population likes music better if you replace "baby" with "jesus", as Cartman would say, there's a segment of the audience that just wants their tropes and doesn't care about the rest.

Lifting his vibro-fork to his mouth, Colonel Daringman watched the exquisite spectacle of planet-rise through the plexi-viewport. He took a bite of his lightly marinated nutribeef simsteak.

‘Needs more NaCl-based SupaFlav flavour enhancer,’ he muttered to himself. The meal had been prepared to his exacting standards by the ship’s Cyber Hospitality Electro-Famulus, but there was always room for improvements to the AI’s food preparation algorithms. He made a subconscious neural-jack-formatted mental note to update the C.H.E.F. unit’s programming.

Just then, the A.A.A. (Audio Alert Alarm) began emitting the high-pitched ringing noise known as “spidiffling.”

‘Zakradav grakhl!’ swore the Colonel.

But at the same time, the arena of science fiction exists to explore concepts in ways that conventional literature or television cannot. Given an hour in which everything about the world is known (Brooklyn 99) or an hour in which a new concept must be explained, explored and then resolved (DS9), much less of the hour can be devoted to the decorum you so crave. You see this as bad writing. I suggest you go watch Philadelphia again, in which 70% of the film is given over to "Here is your AIDS F.A.Q." Two Oscars, five nominations. The biggest beef the intelligentsia had with Philadelphia? It spent way too long on AIDS 101. Yet for Middle America it was the movie that made that whole Magic Johnson thing make sense.

I don't think you're being duplicitous. I think you're blind to an aspect of your personality, namely that some things just straight-up make you uncomfortable. And that's fine. At the end of the day most people would agree that science fiction is sub-par and not worth their time. There's a reason 99% of it these days is fuckin' superhero dreck.

But most people wouldn't accuse science fiction of being crap but Kaiju films of being great.

That's all you.