I think the first Borg episode, Q Who
, managed to have a creepy tone, and, to a much lesser degree, so did part one of The Best of Both Worlds
Unfortunately, that tone had evaporated somewhere before the climax of The Best of Both Worlds, Part II
, and it never came back. I Borg
was already pretty cheesy, but Descent
was unintentionally comical.