i don't think frank herbert completely goes off the deep end until god emperor of dune. i wouldn't call the books bad at that point but they don't have the same feel to me as the first three books. to be honest the second and third books should have been a single book too. at any rate read up through at least children of dune. once you hit that point i'd go back and read the prequel novels by brian herbert and kevin j. anderson.
if you want the whole story its worth reading on from good emperor of dune but for me those books felt like they lacked something the first three books and the prequel books had. even the two finale books were no where near as good as the prequels even though they were written by the same people. they were worth reading to finish out the story but they just weren't as good for some reason.
they've been releasing some side books recently that cover missing points of history during the original dune saga and those are decent, but i'd read all the other books before getting into those.
-----signature-----
MyAnimeList -
http://myanimelist.net/profile/Grimtempest
- Chaotic Neutral -
El Psy Congroo