DUNE is (one of?) my favorite fiction reads and I have to resist turning all "fanboy" over it sometimes.
I love the sensation in DUNE that I'm inside a fully fleshed-out universe where the vision is so large I can't even see the edges, but here's one thread you might find interesting.
...that said...
I never really "got" the rest of the series. Never felt like Paul and his actions were acceptably justified beyond "yeah we would've all died out, trust me".
Separately, the whole, uh, female superpower thing came off as eye-rolling simp-nerd fantasy that wasn't up to the standard of the first book. It wasn't even spice-induced, it was just /muscles/ taking over mens' minds.
> non-fiction
I have some bad news for you...
With that being said, Frank Herbert certainly (IMO) is a genius of pure vision and worldbuilding but he is a serviceable writer at best.
By the aforementioned fourth book, he no longer has anything to add to his consideration of prescience/fate and is increasingly focused on sexuality. And his writing on sexuality is about as un-sensual as I can imagine.
There's plenty in there still about prescience.
I actually like what Hurbert did with paul. He made someone that was a god amongst man and then completely destroyed his legacy. Paul both was and wasn't a hero depending on the perspective of the person in the story. Herbert did a good job of showing the dangers of worshiping an authoritarian leader.
And we basically just have to take Leto II's word at face value that he was preventing humanity's extinction, but...
By the time of Heretics, Herbert was basically coming right out and saying that prescience in fact alters the timeline rather than "just" predicts it. Which is kind of crazy if you think of two things:
1) Every Guild Navigator using the spice induced prescience to plan and fold space is altering reality
2) Spice comes from an alien being. The only aliens in the Dune universe.
(disclaimer: I don't count Brian Herbert's books & and whatever might be in there... what I read of those made me not want to read more)
knees