There’s a whole extremely famous book series on this very topic, you might have heard about it. The first volume’s title is ‘Paul is bad’ but it’s more widely known as ‘Dune’.
That is, sincere with terrible consequences for bystanders. Not bad per se, but not conducive to the common good.
I also felt that the books undermined the warnings of tyranny by leaning on prescience to provide an ends justify the means argument. Moreso with God Emperor where the Golden Path seemed to be the ultimate end justifying any act.
It’s when fiction becomes non-fiction that it’s a problem.
The story is a classic narrative of hoped-for ends being used to justify horrible actual means, but cloaked in space opera.