VindictiveJudge

I think the police state was their solution to infighting in much the same way that Surak's faction took up a quasi-religious adherence to logic.

"We wouldn't have to eat Kraft dinner!"

"But we would eat Kraft dinner."

"Of course we would! We'd just eat more!"

I didn't even get to listen to all of it because the app always wants to autoplay Hegemony.

Alternatively, do what they did with Bashir and suddenly reveal that he replaced Bradward at some indeterminate point during season 4.

I'm pretty sure he was also the only command division officer on the bridge after they gave him command. At least in theory, due to differences in training, a lieutenant jg from the command track may be better suited for acting captaincy than a full lieutenant from science, especially with a decidedly non-sciency mission like flinging a warship at a wall. You need that dash of crazy that Starfleet's command officers tend to have.

SNW actually uses warmer lighting than this DSC shot, which helps the set look much more like an updated version of TOS's bridge set.

Voyager had phasers on the pylons. The Enterprise-D actually got phasers added to the nacelles, of all thing, in a later season. I don't think either ship was actually seen firing them, though.

You live on the Moon?

10 bars of gold pressed latinum can buy many peanuts.

Been a while since I watched First Contact, but I thought they did more than just kill the Queen. Could be wrong, though.

On Section 31, that's the current story, but DS9 had their existence so secret that it's implausible in combination with how open they are in DSC. It'd be like the US disbanding the marine corps and then trying to pretend they never had one. ENT's bit where they quoted the charter also has them pretty clearly deliberately misinterpreting what Article 14, Section 31 actually says.

Harris: "Re-read the charter: Article 14, Section 31. There are a few lines that make allowances for bending the rules during times of extraordinary threat."

Archer: "What threat?"

Harris: "Take your pick. Earth's got a lot of enemies."

That sounds like it's intended to be meant to cover the wacky reality destroying shenanigans that Starfleet crews tend to get mixed up in. Breaking time travel laws to retrieve whales from the past so that Earth doesn't get wiped off the map, for instance would be covered under art. XIV, §31. Or interfering with the internal politics of the Q Continuum because they're blowing up random stars. Or landing a strike team on a pre-warp planet because they're messing around with Omega Particles. Messing with Romulan internal politics because they hate us doesn't qualify because the Romulans aren't about to wipe anyone out. Romulans are an ordinary threat, not an extraordinary one. That's just Tuesday in the Federation. Harris' quote also doesn't imply that the charter actually calls for the creation of an entire branch of Starfleet to handle such threats.

Before DSC gave them badges, the logical conclusion was that S31 in the prime timeline was an illegal conspiracy among Starfleet officers, not an official organization in any way. Even Into Darkness' portrayal could potentially be interpreted as a S31 conspirator in that timeline getting high enough ranked to move lots of resources on the sly, though I'll admit that's stretching things.

I don't think that's too big of a concern, to be honest. You can't negotiate with a spacial rift and the show handles that kind of thing fine. I think they were having problems with First Contact's script and decided to solve it with a named antagonist rather than just hordes of Borg.

She wasn't too bad in First Contact. The movie implied that she was simply an avatar for the Collective, not too different from Locutus. Later writers didn't get that and VOY turned her into an individual within the Collective who controlled all of it, somehow. Then her depiction just kept getting further and further from her depiction in First Contact, mostly keeping superficial things.

Section 31 went through a very similar shift, where DS9 implies that Sloan and S31 are rogue agents and Sloan is talking out of his ass in regards to any real authority and taking an, at best, extremely liberal interpretation of the Starfleet Charter, then later works making them an official part of Starfleet.