i gotta be honest as someone who have all the old books
up to god emperror included.
for me only the first dune and dune messiah were good.
children of dune was an absolute garbage and by what i heard god emperror is boring.
i know alot of people dont like messiah as well but i liked it. but children is terrible.