This is based on opinion. Please don't list it on a work's trope example list.
Nightmare Fuel / Space: 1999
The very premise of the series scared some in a way Star Trek never did. Whenever the base lost personnel, and equipment, that's it. There will be no replacements, and they are in growing danger of running out, especially since they apparently have no production facilities. That makes every death of Red Shirt characters feel like a horrific loss.
Both played straight and partially averted in the Expanded Universe of novelizations and comics, where the Alphans were occasionally shown to have some limited mining and production facilities, but still had chronic supply problems. (Especially in season 2, where a crucial metal called "tiranium"(sic) always seemed to be in short supply.)
It's debatable that they had no production facilities. In the first episode, Alpha was likely involved in the construction of the Meta Probe, and having a construction base outside Earth's gravity well would be one of the best justifications for having a Moon base. Alpha's Technical Section was the largest section on the base, and included rocket propulsion engineers, general maintenance crews, mining personnel.
The episode "Dragon's Domain", and that scene with the tentacled monster dragging screaming personnel into its mouth and spitting out dessicated, char-broiled, smoking corpses...
An episode involving a pair of twins with some kind of voodoo power. The girl produced a very lifelike clay bust of Dr. Russel's head and proceeded to sink her fingers into the middle of the bust's face. The resulting scream of agony escaping from Dr. Russel's own fingers as she pressed them over her own face still can haunt nightmares.
The fate of Commissioner Simmonds in "Earthbound". After forcing his way aboard the vessel of some friendly aliens (who are, conveniently, headed for Earth) and who've agreed to take one Alphan passenger along for the ride (since they have a spare hibernation cubicle), Simmonds awakes inside the glass cubicle only minutes into the voyage. Turns out, the aliens' suspended-animation process doesn't work on humans... and the aliens are asleep, and the cubicle can only be opened from the outside...
It does work on humans, but they had to check the staff to see who'd be most compatible with the system - and Simmonds forced his way in before it could be completed. And just to rub it in, guess who the computer deemed to be the one most suited...
They didn't have to check who was most compatible. Dr. Russell runs tests and confirms that the process would work with any human, but Zantor points out that it would have to be calibrated to the chosen individual. Simmonds suffers his fate because he doesn't allow Zantor to carry out this calibration. The computer selection was simply to choose an Alphan at random, but it's insinuated that the reason Simmonds was chosen was that he was the least essential to the continued survival of the base.
The fate of Dr. Rowland in "Death's Other Dominion".
The titular "Troubled Spirit": Dan Matteo's "ghost".