A needle is shown moving towards a man's eye. It touches and bends the "outer layer" of the eye but does not puncture it. (Stylized visual effect, happens in a vision/dream.)

While a man looks in the mirror, a metal spike shoots out of his cheek. No blood or gore. (Happens in a vision/dream.)

A Borg grabs a man by the back of his head and uses two tubes to inject him in the neck. We then see the man starting to transform into a Borg. The man is shown lying on the floor shaking tremulously and painfully as machines attach themselves to him. He begs Picard for help and Picard mercy kills him by shooting him in the chest. (No blood)

Various Borg are shot with phaser rifles.

We see two drill bits drill into the temple of an androids head in closeup, the skin is drilled into.

The Borg queen is first shown as a disembodied head with a mechanical spine lowered onto a mechanical body.

We see Borg with various mechanical parts attached to them, including machines attached to their face, whole limbs being replaced with mechanical ones, even a mechanical eyeball. This scene is disturbing but brief.

Human skin is being grafted to an android's body. Later the skin is shown cut and bleeding.

The Borg shoot a hologram's head with lasers. The hologram's head flashes on and off.

A couple of Borg are shot by the protagonist with bullets. He then digs around in their chest looking for a circuit card. It is stated that these Borg drones he killed used to be members of his crew.

A mechanical arm is cut off, no blood or gore. Then a blade is shown cutting into a Borg's neck, blood is shown.

A Borg is shown having its organic parts evaporate.

'Bitch' is said.

'Bullshit' is said.

"Jesus" is abused once.

A man and woman are shown drunk and still drinking.

Very briefly a man is holds a bottle with a cigarette in his mouth.

Zeph Cochrane is apparently an alcoholic

A man is shown drinking from a flask.

In the Holo Deck, Captain Picard shoots the Borg with rage and with bullets.

An emotional intense moment when a man gets angry and smashes a window.

The characters are working to stop the destruction of the population of Earth.

The scenes with the crew fighting the Borg are very intense.

There are several jump-scare moments.