Loftwings and Demons

Have never really got into Dune.  Maybe because I've only tried to watch the movies/shows, not read the books.  But every time I hear someone describe the story in any form, it just sounds sort of unappealing.  Given my small knowledge of the story, my summary for it is thus: Everyone is doing drugs, but not the fun type, apparently.  Negative amounts of fun are being had.  Top drug dealer is an inherited title?  Maybe a giant worm is going to pop out and eat someone.  The giant worms are the only ones having any fun.  Oh, and there's some really pretentious line about fear.