The pilot was the last episode of ten or so that they showed. There might be a few more shown, but Fox declined to pick it up for next season. Supposedly, they're still working on trying to get someone else to produce it. It was often excellent. Unfortunately, the first few episodes of it that they showed were just kinda boring.

I tend to agree with you about all of those show except DS9.

The best science fiction TV show of all time, though, was Max Headroom.