I just don't get the objection to the notion that people might like stories about characters who are the best at something. It's been a hallmark of fiction for ages. In their perspective fictions, James Bond is the best spy. Sherlock Holmes is the best detective, Rambo is the best soldier, & Kirk /Picard command the best ship & crew in Starfleet. It's not pretentious. We WANT stories about people who are the best. It's aspirational. It's badass
Well, it's not really the same. Holmes was the best because he invented his own profession and was the only one doing it. Bond was also nearly unique, part of a very small number of 00 agents. Rambo, of course, a loner.
That's quite different from being one small part of what is supposed to be a very large and highly capable organization. Of course, the necessities of the drama will always have the hero cast doing things better than their supposed equals. Taking it a step further and actually highlighting how exceptional they are in their own world is, to me, a bit bewildering as a dramatic choice. If everybody's always talking about how great they are, then of course they overcome all challenges; they're the best after all. Failure is for those other poor bastards, you know, the ones that aren't the best.
Obviously not everyone minds this. But what I wonder is, what advantage was there to writing in this exceptional element? What if other characters talked about how great Perry Mason or Columbo were, how exceptional they were at always winning/solving their cases? Even if the viewer knows that, it would undercut the dramatic feel. What would be wrong, dramatically, with the
Enterprise crew being a very professional, dynamic, capable but at the same time unexceptional part of Starfleet?