He's not a household name because he's too damned good, that's why. Just look at the general popular culture and you'll see that more formulaic the movie/song is, in general, more popular it is. This applies to Gene Wolfe, Matheson, Bradbury, PKD, Ellison and countless others. All literary giants whose movie adaptations a lot of people have seen without even realizing it.