I stand by what I said before -- it's invalid to atttempt to argue about such things on the level of individual characters, since the words describe the overall approach of the story and its worldbuilding. TNG was utopian in that it chose to portray an idealized humanity with little conflict. DS9 challenged that utopia while remaining consistent with it, by taking characters from that idealized society and putting them through hardships that challenged their ideals, as well as playing them off against characters from more dystopian backgrounds to create conflict. You could have swapped out individual characters from one series to the other and they would've adapted to the approach of the overall series. Indeed, exactly that did happen with the O'Briens and Worf. The characters were the same, but their context changed to be less idealized. That's why your attempt to define the question in terms of individual characters just doesn't make sense.
And that's fine. Just don't assume you're the only one who graduated high school the next time. That's what I reacted negatively to.
And I still disagree that the individual character level can be ignored. The OP already talks about individual characters ("Janeway is cold") and I approached from that perspective before you started ranting at me.
But still I'd say that TNG frequently didn't portray a humanity that was *that* much more idealized than the DS9 one. I say they were on the same level. Yes DS9 tested more and challenged them more, but in the end they were still very idealized.
I think I've made it clear that I reject the entire premise of this thread, that even using the word "dystopian" to talk about any Star Trek series is an erroneous application of the word.
But that's exactly what I meant, my point was that the Star Trek series that the OP calls "dystopian" are not that much more pessimistic than the one he calls "utopian". There's nothing dystopian about Picard or Discovery.