Re: The scary/creepy moments of TNG
ST was often pretty effective with the execution of spooky scenes (even Catspaw has its moments). It's not just the writing, staging, lighting and performances, but effective music could also strengthen a scene's impact. Though I'm usually not complimentary toward Rick Berman's taste in effective scene music.
Dr. Howard, Dr. Fine, Dr. Howard: For duty and humanity! --Men in Black (1934)