80
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"?
(startrek.website)
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:
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.
Hear hear. There's still a lot of good in there even with the examples you have given