Someone else said my favorite one so ill go with another that i like a lot.

The scene with picard and wesley and picard gives him the speech about telling the truth.

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!

Bonus: My favorite silly moment was when time was stopped/very slowed and picard draws a smiley face in a warp core breach