I didn't like the 2000 SyFy miniseries at all :( It looked so... cheap and campy. There are plenty of flaws in Lynch's Dune, but it managed to look awesome at times. The meeting between the Emperor and the Navigator is awesome and ominous. Nothing in the SyFy miniseries matches this. And SyFy's Baron Harkonnen manages to look completely non-threatening :(
I really hate the miniseries.