It’s a cargo cult. Dune itself is pretty standard sci-fi. The sequels are where it goes from good to great. People deify the first one because they think that’s where the great reputation comes from, not understanding that the really interesting stuff is in the later books. I mean, the giant worm-man, the endless clones experiencing existential dread, and the trans stuff all come after book 2 and really after book 3.
I've only read the series once, >20 years ago, but I thought the opposite. To me it started out good but ended weird and stupid (I admit I remember almost no details though, so can only give the impression I'm left with). I've read other books I thought much better than any of them though.
I couldn't make it after the second book, Dune Messiah. But I enjoyed the games, especially the RTS, the miniseries and the recent movie which is quite good.