One of Star Trek's greatest modern flops wasted a concept with huge potential, one that a sci-fi on Prime proved could have led to something great.