I actually went into a lot more detail in my response to another person in this same thread, but his message was intended as a warning against putting all of your trust in charismatic leaders...although his actual comments in that interview are much more nuanced than simply saying, "charismatic leaders are bad".

Villeneuve seems to have a very simplified understanding of that concept in mind, when he came up with the idea that Herbert wrote Messiah in response to fans missing the point of the 1st novel. But, Herbert himself spoke at length about what he intended Paul's character to be about...and he wasn't the "bad guy".

Without repeating myself too much, Paul was a "tragic hero". Herbert intended for him to be like a perfect example of what a leader should be. And his story was meant to highlight that even a perfect leader is still human, and will inevitably make mistakes...and may also be forced to make dire sacrifices in order to achieve results.

The basic moral of the story is that "great leaders" are very rarely "good people"...and that even the best leaders will have to make hard choices, that ultimately harm at least some of people they rule over. Paul was meant to be a "best case scenario"...but in the end, even he failed in his attempts to get everything right.

And his compassion for those he ruled over, actually prevented him from doing what he needed to, in order to save humanity from an even worse fate than himself.