As the sprawling franchise returns to our television screens in the form of ‘Dune: Prophecy’, Greg Evans takes a look back at when SyFy boldly adapted Frank Herbert’s first three novels in an ambitious and bizarre TV event