Just to put in my two cents:
I thought the Lynch film had the better production design. I don't think I could better imagine many of the costumes, ships, and even actors than what we got in the Lynch film. However I do think the SyFy miniseries gave the story more appropriate time. I also think some of the actors rivaled their Lynch counterparts, and arguably the Harkonnens exceeded them. The miniseries production design was weird but I give them props for trying to be out there, for making it different than what we had seen before with Lynch's film. I also liked the expanded role for Irulan and for Shaddam's sister in Children of Doom. From what I recall, I don't remember her being as prominent in the books.
As for the Frank Herbert novels, I loved the first three novels. God Emperor of Dune was the dividing line for me. I hated that book though I toughed it out, and it took me 15 years-off mostly and on a little-to complete it. I tried Heretics and I just didn't care about those characters. So I put that down and gave it away, along with Chapter House.
With Brian Herbert and Kevin Anderson, I liked the House books a lot, particularly House Atreides. House Harkonnen was the weakest of the trilogy, unfortunately, and House Corrino was a decent close. I couldn't get into the Butlerian Jihad and wasn't interested in the post-Chapter House stories. I started reading Paul of Dune and found it interesting but haven't finished it. I think it's that time period shortly before and during Herbert's original three books that interest me the most. Going too far into the future or past don't interest me.
The Brian Herbert books aren't as good as his fathers, but I did find them easier to digest and some of them had some pretty awesome quotes/passages at the beginning of each chapter. And I liked how Brian's books gave us more of Duke Leto's past since he gets scant attention in the original Dune.