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.
I prefer this to Lynch's film which has great costumes and design but you can't tell Dune in less than 2 hours, like one cannot tell lord of the rings in one movie.
However,there is certainly room for a real trilogy movie. I'm sure it will happen in the next 10 years.
I would say that Paul was throughtful, but very emotive - remember the lecture about mood being a thing for cattle? - and not keen enough on acting initially.
From the get, Paul is depicted as a petulant, unthoughtful child with no desire to move off-planet - which is the exact opposite of who he is in the books.
The fact that Paul is mature for his age is precisely why he takes the courses of action he does in the books.
David Lynch nailed that aspect.