There is a certain... something that some works have over others to launch them more into the geek fandom zeitgeist. Yeah, we all like Dune, Foundation, Culture, etc. But... we don't build huge fandoms around them.
Exactly WHAT it takes? It's partially lowest common denominator. Yes, TV, films...