For me Dune is the best series, even the ones by Frank Herberts son are good.
Growing up I loved the Xanth series. I also liked Star Wars books even though most of them are hit and miss, I just like reading them and putting myself into the Star Wars universe.
I read the first three way back in the early 70s.
I read them again in the late 80s and the 4 additional books as well. They got too weird for even me at the end.
I would not ever even consider reading the "House Atreides" or any of the books by other authors, related to FH or not.
The Azimov Foundation series was fun, and the later combining of that with the old "Robot" series was while intriguing and readable, definitely a challenge for rationalizing diverse Sci Fi histories.
If you like that sort of stuff, I'd recommend some "punk Sci Fi" for you. Bruce Sterling comes to mind. "The Difference Engine" was a fun read. His "Crystal Express" collection of short stories is awesome, particularly..."The Swarm."
David Zindell's "Neverness" was very fun, especially if you like winter sports.
Nothing beats Robert Heinlein though.
More later on this subject when I have time.