Pretty sure that's been established as the concensus by now.
My contribution is that Harry Kim deserved to stay an ensign. Considering how often his impulse or libido resulted in disaster (or his own death), he would have been kicked out of Starfleet entirely. Lucky for him, they were stranded in the Delta Quadrant and Janeway needed bodies.
i never got where people thinking burnham is a mary sue comes from. the whole concept of her character is that she's a cowboy loose cannon without the competence to back it up. it's specifically a subversion of every time our hero breaks the rules and steals The Ship and it ends up being ok because they saved the day or stopped the big war or whatever. the series starts with her trying to do just that, bringing about what she wanted to prevent, and getting arrested for it!
If time travel is said to be impossible yet it is so easily achieved in so many story lines in Star Trek than why didn't they just invent a safe way to travel between periods.
And if there is an eventual temporal war than everything gets destroyed and all life is wiped out in the galaxy. There would have eventually been an extremist group that would have taken the technology to it's fullest limits and traveled back to a period when the galaxy was very young. They would have severely altered everything to the point of not making any future possible.
It always annoyed me that engineers, scientists and technicians could always find a way to travel back and forth through time "just this once because of this reason" .... yet no one takes up the science to recreate the event and bake technology to purposely travel back and forth through time.
Strange New Worlds, the show that should have brought Star Trek back to it's former glory is horrible and unwatchable. People that behave like teenagers, not professional Starfleet officers. And they made Spock an Emo kid.
I don't get why the bringe of (at least Picard's) Enterprise is located at the top of the ship. We often see ships suffering hull-damage, sometimes scraping each other and getting into all kinds of perilous situations. So why put the room with the most important people in such a vulnerable position when you could put it at the heart of the ship? Bridge would be less likely to suffer from hull damage and decompression. Also, why don't enemy factions just go: Oh that's the bridge. Jolly good. Aim torpedoes at it, watch their morale crumble to dust alongside the bridge crew and call it a day.
Picard should puncked Q. Pull a Sisko man, Q will get the message.
Janeway was wrong to kill Tuvix and the ends did not justify the means. We have no idea how Tuvix would have performed long term, but he was generally better than the sum of his parts.
To kill a sentient being, effective in his role and pleading for his life, just so you can feel less sad, is a crime.
Where My Heart Will Take Me is actually an amazing theme song.
