What is the best closing scene in the entire Star Trek Franchise, and why is it Kirk, Spock, and Bones singing "Row, Row, Row Your Boat"?
Seriously, though. In my opinion, V is by far the worst TOS film, if not the worst of any Star Trek film (Yes, including Kelvin), yet it somehow nailed the ending.
Not to say I hated V that much. I think there's some charm of Kirk, Spock, and Bones breaking out the brig, but the plot is catastrophically bad. I was also annoyed with that one scene with Uhura where they have her seduce some acolytes, which I feel is a disgrace to the character.
I will clarify I haven't watched a lot of Discovery, Enterprise, or Picard.
However, problems of the sort you mention (not necessarily the exact ones you mention, but similar or of concern) aren't exactly new.
For instance:
TOS showed Chekov assaulting a Klingon women (under the influence of an evil space alien before).
It is heavily implied Spock did something with Saviik in III. Also, in general, they just ruined a good female character. (III might actually rival V in terms of being the worst Trek film.)
TNG did "Code of Honor".
Also, TNG very much did weird things to Troi, including rape to rape-adhacent things. Not necessarily as bad as T'Pel, from what I can tell, but still messed up nonetheless.
I'm sure there's an example for DS9, but my mind subconsciously puts it in a pedestal and is blocking me at the moment.
VOY unnecessarily sexualizes Seven.
I think the truth of all Star Trek is it is flawed, but that we can critically acknowledge those flaws while managing to look past them so we can appreciate and enjoy the good parts.
Enterprise doesn't deserve to be in that list. It may not have been everyone's cup of tea, but it's way closer to the other series than Discovery or Picard.
Also, uh, sibling sex and pro-slavery comments? I must have missed those episodes.
Enterprise is the one with the pro slavery comments. And pro human trafficking too. And the weird sibling sex.
Cogenitor episode, the moral of the story is "slavery can be a cultural thing and it's wrong to oppose another culture for that"
And then the horrible episode with orion slaves that says that these sex slaves are not only enjoying it, but are the evil ones, with even the slaver saying that they are the ones in control.
For the sibling sex it's this creepy episode about eugenics and a relative of Soong (if I remember properly) where a bunch of kids who were raised together start fucking and fighting to decide who fucks who. Yeah, they are genetically not related, but in the end I don't want to see sex scenes of teen siblings, sorry.
In Cogenitor, Starfleet wouldn't get very far if it had to roll up to every first contact demanding a species conform to human morality. It has to take a neutral position or first contact becomes an ultimatum. That doesn't mean Starfleet is pro-slavery, it just means it recognizes that it's not in a position to force that change on a species it met five seconds ago. Now if the species was trying to join the Federation (down the line) obviously that's a different story...
The Orion episode too... Uh, weren't the "slaves" actually just pirates? Can we trust anything said when it was just a setup to steal the ship? Not to mention that just because a character says something doesn't make it true or reflect the morality of the show/writers. Maybe that Orion is just an idiot or rationalizing his shitty behavior...