Dune had no good guys, none at all.

Everyone was out for themselves or their narrow view of what was just and best for humanity from their simplistic and self-centered perspective.

Leto 2 was the exception because he was out for his narrow view of what was best for humanity from his broad, self-centered perspective that still didn’t really lead anywhere.

The actual point of the books is that no ideal survives the test of real time, and over time civilization tends to ossify, so we are doomed to catastrophe by our very nature.