He was a great Aquaman. And I like him on Stargate Atlantis.
Most of the things he's been in more recently are just not very good writing wise (Dune is not one of these). Even a great actor can't turn shit writing into something good unless they adlib line changes. Him being someone who is generally typecasted for his looks also doesn't help.