i just think people need to take it with a pinch of salt, and whether or not it's realistic is missing the point.
It's like dismissing Superman or Spiderman as unrealistic, since an alien to comes to Earth as an infant and has superhuman abilities due to the Sun's rays is unlikely.
I see this problem often, in various mediums. Some people confuse "realism" with "believably." The distinction between the two is especially important in sci-fi and fantasy, in which the former need
only be maintained when doing so helps to support the latter. But if internal consistency is maintained and the world remains believable within whatever rules have been established for it, then it's in the clear, whether or not it's "realistic" by our standards.
Which Roddenberry vision are we talking about? Because TOS showed Humans to be flawed beings, still prone to the same faillings of today's mankind. However, it also showed that, with effort and perseverance, Humanity could build a better world. That was what Star Trek was about. That in early TNG that vision of Star Trek was transformed into a "We're all evolved now" fairy tale should not have hindered the DS9 writing staff.
In TOS, Kirk chooses not to kill the Gorn. In early TNG, Picard would have probably said that he had evolved beyond such emotions, and felt no need for revenge or had any kind of blood lust.
Which is better from a dramatic and philosophical point of view? To face tentation, and through sheer force of will, manage to avoid it? Or being simply incapable of being tempted, therefore removing any possible danger?
Exactly. TNG (the first two seasons of it anyway) was Roddenberry vision 2.0.
Yeah. While I love TNG (it's
just barely edged out by DS9 as my favorite Trek show), I consider the first season to be quite bad, and specifically in terms of that preachy, over-the-top holier-than-thou garbage, it's probably the single worst season of the entire franchise. I've always maintained that TNG as a whole isn't nearly so bad about that particular aspect as that first season is (and the second season as well, to a lesser degree). I'm no huge fan of TOS, but I respect it for laying the groundwork, and frankly, "Roddenberry's TOS/Roddenberry's TOS vision" is far superior to "Roddenberry's TNG/Roddenberry's TNG vision". The less direct influence and control Roddenberry had over TNG, the better the show got. Roddenberry was clearly a good writer, and of course the setting and structure for Trek as a whole exists thanks to him, but some of his ideas (especially during the early TNG/early-mid TOS movies eras) were just plain awful.
That said, among all the shows, I do think DS9 struck the best overall balance of optimism vs. skepticism/realism/pessimism/ism ism ism. It maintained the basic concept of "Humans, on the whole, are much better, much wiser, and just overall much nicer people in Trek than in real life",
but it smartly discarded any notions that Humans (or ANY sentient lifeform) should be regarded as "flawless."