Another TV adaptation worth mentioning is SyFy's miniseries "Frank Herbert's Dune" and "Frank Herbert's Children of Dune". They are much more faithful to books than Lynch's movie and better show the epic universe that Herbert imagined.
I also thought they got the tone of Paul's character completely wrong. To me he came across starting off as an arrogant thug whereas my perception of him from the books was a very thoughtful if not perhaps demonstratively emotive young man. (Obviously subjective viewpoint, but it put me off right from the start.)
OTOH, the audiobook produced by Audible I thought was very good. I've probably read the book four or five times, the last time well over a decade ago. I listened to the audiobook recently and really enjoyed it and reminded me how much I liked the first book[2].
[1] Have not seen the Children of Dune miniseries.
[2] I'm in the "first book was good, the rest was crap" camp. I read through 'til about halfway through Heretics of Dune before asking myself why I was still reading and stopped.