I agree with outofsalt.
I thought Dune was great, didn’t care for any of the books that came later. I kept hoping they would get better but IMHO, they didn’t.
Did not like any of the movie versions, but some of the casting in the 1984 film was interesting...too bad the movie had a crappy script!!!
As far as a gothic novel is concerned(I’m not sure it’s really a gothic novel, but it sure held my interest and is definitely imaginative),you may like the Gormenghast novels by Mervyn Peake..at least, the first two. IIRC, the 3rd in the series was written several years after the first two books, and also after Peake had suffered a serious illness, and seemed like a different book altogether..anyway, hope this helps!!!
The only books I have ever enjoyed as movies were by Tom Clancy. The only video product that I found to be better then the books is Game of Thrones.