TNG is also my favourite theme, but my favourite scene with music is the flute song Picard plays for his son’s birth in “The Inner Light” (especially the reprise at the end with the real flute from the probe).