Larry Niven wrote a piece about how hard it is to write detective science fiction stories. I can't remember which book it is the preface to. Anyway, his point was that it's too easy to find an undetectable way to commit a crime when anything is possible, and equally easy to find a new way to detect it too. All the stories become Deus ex Machina. In many, more earthbound, detective stories, the fun is often guessing the villain before the fictional detective does, but that is impossible if the solution depends upon something totally unexpected and unlikely. So, the stories are generally unsatisfying.
There have been such TV shows though. I remember something called Star Cops from the 1987.