Eh, big shrug emoji from me as a massive fan.

If you already read Heretics of Dune you might as well because it continues the story, but it ends on a cliffhanger and then Frank Herbert died before writing the final book of the series so it doesn’t actually culminate with anything. IMO you only “have” to read through God Emperor of Dune to get the payoff for the Atreides story, and can take or leave the last two books.

Also I strongly recommend avoiding the Brian Herbert stuff unless you like Star Wars EU style pulp.