I really couldn't care less if Star Trek follows progressive ideas,
Myself as well,certainly not exclusively, like it was running down some kind of checklist.
I want them to follow realistic ideas.
More realistic is what we saw, a fictional Starfleet with different characters holding a dversity of ideas and concepts, seen amoung the main and secondary characters.
We saw this with Worf during TNG, it was obvious in certain scenes that owing to his culture his mentality was different than say Picard's. We saw this through his advice and personal decisions. When Worf declined to donate tissue to a dying Romulan and was resolute on his decision, he stood out .
From what you know of Worf's personality, would you describe him as progressive?
Boy have you got the wrong franchise
No, he's got the right one.
Kirk wasn't Picard, and Picard definately wasn't Sisko or Janeway. Kirk undeniably wasn't a progressive, but most likely Picard was. But they're both enjoyable characters in the Star Trek universe.
The Federation is composed of hundreds of members, and they (should) each bring a multitude of separate ideas and beliefs to the Federation. Not all of which would make sense or even be comprehensible to the other members.
People within the Federation poisoned the founders, and when the Federation council found out about it the council hung onto the cure allowing the poison to continue it's work, sound progressive?
The Federation in Picard made certain decisions concerning artificial lifeforms, did those decisions sound particularly progressive to you (assuming you know what I'm referring too)?
The Federation certainly has progressives, but it isn't itself a progressive organization.
I'd say Starfleet is neither exclusively progressive nor conservative, possessing elements of both.
Nerys Myk, would you watch a Star Trek that challenged you? Where the much of featured hero group didn't line up your own political/ social/ cultural exspectations and preferances.
Because that is what you've been watching.
It was implausible for any of the human Starfleet officers to be able to go one-on-one in hand-to-hand combat with the Klingons
My impression going back to TOS is that the Klingon aren't as a species stronger than Humans, in fact I think they're slightly weaker. As in any group there would be individuals with above average strength, Kurge in TSFS seemed unusually strong for a Klingon.