And as much as I love Star Trek, a Star Trek fantasy is the last one I'd see in such a man. Star Trek captains righteously flout all the rules. When superiors order them to stand down, when their fundamental laws (the Prime Directive) deny them the power, when the lives of entire worlds are at stake, they do what they think best, damn the torpedoes, warp 9, engage. A man with such delusions of grandeur ought not be put in charge of HUD, much less a secretive organization known for its willingness to spy on citizens.
I also love the Roddenberry canon, but I disagree with your evaluation. I think you are missing the kind of "love of the contradictions" attitude that I think it shares with other religious canons. For instance, take money. We start with a vision of earth utopia 300 years in the future, where nobody is short on cash, short on food, short on housing, or short on medical care. NOBODY. And no more national wars on our planet. All that shit was *solved by smart people over a long period of time*. Or so the vision of utopia goes. But then comes the story of the voyage and exploration. Just as soon as we widen the sentient-social galactic camera angle to just a bit wider view, you see that all of a sudden, our side, is back to having wars (cardassians, borg, dominion). Oh, and I forgot the other big utopian factor- *NO STATE SPONSORED OR CONDONED TORTURE* (allegedly, we'll get to section 31 soon). But as soon as we meet the cardassians, the borg, the dominion, we see that our side is again no longer in any actual future utopia, but rather subject to the timeless problems stemming from the darwinian nature of life, just at a fractally increasing scale. In fact I love Gene Roddenberry's Andromeda because it takes this to the level of galaxies as large complex life forms, also in a straightforward darwinian struggle for survival at a larger scale. I'm sure someone could write a book about multiple 3D universes all born of 4D black holes in some similar struggle for survival, reproduction, durabiity, and otherwise continued existence. In general those complex systems that fight to exist, unsurprisingly populate existence (or at least, the fittest contenders among them). But now, lets not forget about God. The Trek canon also does an extremely good job of obvious sci-fi imaginings of many different God-like entities. That all (or most) interestingly "ring true" with what many spiritual people see as interaction with "God". Satans too. These stories I think help many anti-religious people to understand religious people, and vice versa. If there is any kind of art we need more of in the world, I think that is it. Or helping people of one religion, better understand those of another. Or even racists vs non-racists. Trek is overtly racial, with species taking place of races, and embracing significant cultural and biological differences. I.e. not trying to have a naive anti-racist view of "we are all created equal". We aren't. We are different. Some thrive and survive, some don't. Often it's a viscious cruel battle to see who does.
But I digress, getting back to your point- it's about embracing the contradiction. It's about the shades of gray. Utter, 100% loyalty to orders is something that needs to be shown and taught as horrendously dangerous. We do this with the history of WW2 and elsewhere. We do this with artwork like Trek. Trek shows a *balanced* view of what acting ethically means. Trek shows a *realistic* view of what kinds of situations military leaders and others face. Every kind of ordinary common corruption in today's world has been expertly dealt with by Trek (if you search for the steganographed theme played out in a fictional future).
To claim that ethics will ever boil down to anything other than the type of "maverick captain" scenarios described by trek is I think the problem with your opinion. The ethics of Trek may lead people in positions like Snowden to say- "To Hell With The Law. An unjust law is no law at all.". And that is a good thing. It is the final check and balance on society, more fundamental than even the concept of democracy. You have a choice. It's part of being alive. Get used to it.