Starfleet seems to be just that: competent, usually very trustworthy, fair, and honest. Almost equally unbelievable is a society that isn't incredibly emotionally dysfunctional. There is little in the way of psychopathy, narcissism, addiction, unhealthy ideological fanaticism, or depression on display among the protagonists.
Cyberpunk has proven to be the most prophetic of the sci-fi genres by far. It's done that by being technologically optimistic and socially pessimistic. So far it seems right on-- technology continues to advance, but globally it looks as if the normal arc of society is from freedom to despotism followed by a decay into syndicated criminality. The mafia state -- almost exactly as depicted in the common cyberpunk setting -- looks like the ascendant future. If there are warp-driven starships in the future they will likely be flown by the various factions of the Russian mob, the American criminal overworld, Los Zetas, Chinese Triads, and of course the Yakuza. If they look like contemporary business and governmental organizations, the captain will be a narcissist/psychopath and his immediate subordinates fawning codependents.