I would have loved to see Starfleet and the "adventures" of the crew from the perspective of a civilian or a really low-ranking officer. Not in a cartoony/jokey way, but it's treated so flippantly that "god-like" aliens exist and one race of them tried to end humanity or shape-shifting aliens or cybernetic aliens that want to enslave the galaxy or holograms you're playfully murdering repeatedly while you play Call of Duty part 1000 are actually sentient (or have the potential for sentience) or time travel being such a ubiquitous thing that it could erase your entire life. I didn't even mention that a proven multiverse exists.
Yet, for some reason, the average civilian just trudges along as if existential horrors don't exist in every corner and an inept Starfleet crew could accidentally pluck the wrong temporal anomaly and end your entire existence.
I think this is the only example I saw ... kind of acknowledge it ... and it is treated like he's just being a hypochondriac.
Other than that, they had the prejudiced humans in Enterprise (that threatened Phlox) get angry that Starfleet essentially is pointing Earth to every alien species in the universe. But I don't think they were trying to show that what Starfleet does is actually dangerous but moreso that in the end the benefits outweighed the cons.
It's weird to me (unless they reveal that Starfleet covers most of this up). I get the show isn't meant to be about that, but about the Starfleet crews. However, we've had so many shows, novels, games, etc. and you almost never see civilians express concern that Apollo was masquerading as a god but was really an alien. What does this mean for religions across the Federation world?
Nothing ever seems to come out of these transformative revelations and crazy discoveries by Starfleet.
But I guess ... this wouldn't be a
small thing to happen. :P :P :P
How about finally learning what language actually is spoken across the UFP?