It's quite a bit, and there are plenty of variations.
I like DS9, and the amount I like it hasn't changed, but I think it's very gradually gone from under-rated to over-rated. So gradual that you wouldn't notice it until you stop to think, "Wait a minute... "
Exactly.
Can you give an example of such 'farting in the elevator, Federation bad!' episodes that were usual? I'm honestly curious as to the type of episodes you are referring to now.
Not episodes, and not necessarily usual. I mean the much-vaunted "showing that the Federation isn't that utopic" side of DS9: it's not always handled in much of a deep fashion. It's a quick comment by a character or another that amounts to little.
Never quite saw it that way. I just saw it as a combination of a fiery temper and being very damaged, the latter only logical given her background. And she would share that with millions of other Bajorans, given what the planet just went through.
Until a recent rewatch, I wasn't sure what grated me about Kira, but now I know: she throws her weight around whenever she doesn't get her way.
And yes, it makes sense that she's damaged, like most other Bajorans, as I said. Which why I compared her with Ro: they both lived the same trauma and both became angry, but Ro's anger comes from depression, from feeling she doesn't belong anywhere, whereas Kira's comes from xenophobia.
It's partly deliberate, I think: there's a clear arc for Kira where she learns to both be more tolerant and open and to be less xenophobic, starting with "Duet" and culminating around S5, where this exchange occurs between Worf and Jadzia:
"
Major Kira – friends with a Cardassian. It seems wrong."
"
You should have known her five years ago. Back then, I never thought she'd be friends with anyone."
As Jadzia says: early on, she doesn't get along with anyone. She's mistrustful of Sisko initially, until the whole "emissary" thing occurs, she threatens Quark at the drop of a hat, she rages at the provisional government, at the Cardassians, snaps at Bashir the rare times he doesn't agree with her, ...
She has her reasons, but at times, it just makes the character annoying. Imagine working alongside someone like that, prone to either snapping at you or boasting about how tough she's had it. Someone you need to walk on eggshells around. It's exhausting.
I agree that to some extent I couldn't always get the 'feel' of the Sisko character, connect less to him than I could to Picard, too. Picard could be easily placed, you could almost always count on him doing 'the moral thing', for example. Not that that made him boring. Sisko is less predictable. It never occurred to me to connect that to a 'badass' vibe though. It's not as if Picard is indecisive or timid by comparison, though he does ponder (and pontificate!) more.
Sisko has much more of a "ends justify the means" attitude, and it's sometimes the tone of DS9 as a whole.
It starts small, by accepting the whole "emissary" thing to help in accomplishing his mission (Picard would've made it very clear he was no god nor an envoy of the gods - he gets outraged at being seen as a religious figure), ends with poisoning a planet and the events of In the Pale Moonlight.
I don't see that as preaching of religion as such. I see it more as a kind of postmodern subversion of the humanist trope that until then always had run so strongly through Trek. You know, in which 'gods' almost always turned out to be either impostors or in the best case, benevolent aliens with a higher civilization.
So, like in real life (well, the impostors, not benevolent aliens)?
Again, if you trace the points, there's an arc for Sisko: he's initially reluctat to be the emissary, only going along to not upset the Bajorans, that changes with the events of "Rapture" then in "Sacrifice of Angels", he directly asks them to interfere and they do; then in "Tears of the Prophets" he gets some prophecy that he should stay on the station, Ross tells him he has to choose between Starfleet captain and emissary, he chooses the former and is "punished" by Jadzia's death and the prophets being locked out by Dukat/pah-wraiths.
The events of Tears of the Prophets is a bit like Melisandre saying "I could've saved your men at the Blackwater" to Stannis, and Stannis falling deeper into her grasp as a result.
By the end, he's fully into the Bajoran religion, and it's shown on screen that resisting it leads to negative outcomes (Jadzia's death), whereas embracing it leads to positive ones (dominion reinforcements being swept away).
But in almost all cases they were 'unmasked' at the end, and it was left unambiguous and spoon-fed as to what the 'right' attitude to beings such as Q should be. Such episodes can be equally easy and grating especially after the 17th time such a trope is used.
I think it's important to teach skepticism. The lesson wasn't "the gods are fake" so much as "look out for those who would deceive you" as well as "favour the most parsimonious explanation" and "question everything, especially authority".
What's new in DS9 (from my point of view) is not the fact that the aliens are 'gods' that actually real or "serve their purpose" - we had seen that before , and neither the fact that Sisko is revered
within that pantheon - we saw that before too (Who watches the watchers, for example) , but that Sisko is cast in a situation where trying to defuse the situation in a way that was common in Trek till then (by showing the primitive natives the enlightened ways of the Federation) simply
won't work.
On the one hand, here's a civilization with religion so ingrained in their culture that not even Kirk could have talked them out of it, had he tried to do so. And on the other hand, Sisko can't do so in the first place, since he has the assignment to do everything to get them ready for the Federation -a command that only got more important after the wormhole was discovered-, so he can't risk an alienation. So, he has to live with it. At first reluctantly acknowledging them only as 'wormhole aliens', then over the years gradually coming over to the Bajoran point of view.
There's a third option, though: "you're welcome to your religion and I won't try to talk you out of it, but don't force it on me. I am no deity nor their envoy. I will not participate in your religion."
I know the Bajorans wouldn't have liked that approach and Sisko had his mission, but that's the "ends justify the means" approach I mentionned above. Picard was much more about deontology (with some exceptions, as in "Justice"): I won't commit a morally reprehensible act, damn the consequences!
If there is preaching there, I'd see it mainly as the expression of the idea that the viewpoint of others (or other cultures) isn't necessarily invalid simply because it doesn't fit in our framework.
As just above: you can let others have their viewpoint without adopting it/participating in it. If they require your participation, well, the problem of tolerance is firmly on their stide.
Also I think that if I would see it now for the very first time (as someone nearing 50 years of age), I wouldn't be as nearly captivated by it as back when I was an impressionable 23-year-old, because I've gotten a good deal more cynical and down-to-earth over the years and less impressed by things that sound dramatic but simply don't work that way in real life.
Our age does influence our experience with the series a lot, that's certain. I must've been in my 20s when I first watched all of DS9, too (I'm 36 now). Though I'd seen some episodes as a teenager. A TV channel (Club RTL) started showing TNG, abruptly replaced it after a decently long (but not complete) run with DS9, then a handful of episodes later with VOY. It was weird. Next, I caught TOS then TNG on the BBC in my early 20s (late timeslot, always 2 episodes, I really looked forward to that time of the week).
All that to say: I'm probably quite biased in TNG's favour.