I think your other comment is basically right that what Herbert really wanted was a fantasy epic with feudal structures, knife fights, and humans with near-magical abilities, and reverse engineered a vaguely plausible future that might bring that about without invoking any actual magic. Arguing whether this is supposed to be considered "good" or not is kind of beside the point. Fiction novels are mostly meant to present worlds that are interesting to read about more than advocating for or against those same conditions replicating in the real world.

The only thing I've really taken from what Herbert himself said, not something a character in one of his books said, is distrust of messiahs and centralized power being an inherently corrupting force, even in the hands of good people.

Unfortunately, I would have to say right now my bets on the most plausible fictional future becoming reality is WALL-E.