Sagan was prophetic in a much more realistic way, I think. Herbert is fundamentally constrained by the rule of cool. Actual failure modes of the human firmware are rarely cool. We're generally just not very clever at a species level.

My personal view is that biological intelligence is fundamentally an unstable state. We should enjoy every moment of it, like you enjoy the brief flowering of a desert cactus. It's basically the same thing.