You’re missing out, after Children of Dune, the story skips forward about 3,000 years to God Emperor of Dune, where Paul’s son Leto II has mostly metamorphosed into a sandworm and has been ruling the known universe for millenia. It’s at this point that Duncan Idaho becomes one of the central figures of the story.
Sorry, I did flip through a friend’s copy of God-Emperor of Dune on a slow duty-section afternoon during my Navy years. It failed to pump my ‘nads.
The older one gets and the more one learns, the less attracted one is to breathless stories of superhuman individuals. Thats always been an obsession throughout human history.
Our Founding Fathers were the first sensible people to recognize, once-and-for-all, that such people don’t exist and designed a government with that fact in mind.