Let´s talk about Dune...

I think two scenes annoyed me most in all the Herbert saga: that Miles Teg thing, and when Leto was said to be able to lift very heavy things at the end of Children of Dune (my memory may fail me here).

Usually, yes the Atreides line, coming mostly from BGs' manipulations over the centuries, produced remarkable individuals, with incredible abilities. It is in my opinions that these abilities were mostly mental ones, about intelligence, wisdom, seeing fat into possibilities in the future as well as into the past, etc...

The two scenes above remind me too well how Paul was treated in the movie: it ended with him actually commanding rain on the desert planet.

Most of the times, Herbert did keep his characters as mostly and simply humans after all, yes with enhanced abilities, but most of the time it was outside of the "Steve Austin" kind.

And I loved him for it.

Just my two cents.
Just read Heretics and ChapterHouse only once though, and maybe if I read again it wouldn't be that weird to me.