Nobody mentioned Dune yet? For shame! :p
All of Frank Herbert's books are great, but avoid the later stuff by his son. They raped his father's works.
But if you want to know the greatest science fiction author of all time, there is but one man, my idol: