The speech (directed towards Wesley after making a string of poor decisions at the behest of Tom Paris, er, Nick Locarno):

"The first duty of every Starfleet officer is to the truth, whether it’s scientific truth, or historical truth, or personal truth! It is the guiding principle on which Starfleet is based, and if you can’t find it within yourself to stand up and tell the truth about what happened, you don’t deserve to wear that uniform.”

Buffer time is definitely the episode where I stopped doubting they knew how to handle trek.

The Borg have come for the Australian Computer. Unfortunately, it knows their one weakness.

VOY Episode 6x18 "Ashes to Ashes"

VOY s3e3 "The Chute"

Behind the scenes of First Contact

TNG s2e9 "The Measure of a Man" and an unidentified BTS shot from either season 1 or 2

Bruce Maddox's continued career had some later influence. See Picard season 1 for context.

Who's your favorite?

Behind the scenes of ST: First Contact

TNG s4e21 "The Drumhead"