Are we talking about the Mexican(?) surrealist film maker Jodorowsky? I've seen a few of his films and they're... I don't even know. I guess that's surrealism for you. And I'm assuming Dune would have been based on the famous book? Sounds like something I'd have to hunt down, thanks.
He's apparently Chilean, but he worked in Mexico, and his version of Dune is one worth learning of (and the documentary of the parts of its making that happened plays out much more interestingly than most documentaries do).
Nic Cage. He makes horrible films. Absolutely dreadful. On the upside he's a great actor. Interesting thing, that. I also second Dark Star recommendation. An interesting little sci-fi-com. And I can always appreciate a Kubric homage. At least I'm pretty sure it was a Kubric homage. It has a philosophical little chat with a bomb among other amusing bits, unless I'm mistaken on the film.
I can't really say the same, but that's presumably due to different standards on what a dreadful film is. There are a few films of his that are definitely on the lower end of the quality scale (Ghost Rider or Deadfall are ones that immediately come to mind that I've seen, genuinely sub-par films, those), but some of his work, like Bad Lieutenant: Port of Call - New Orleans, Leaving Las Vegas, Matchstick Men, even the sillier ones like Vampire's Kiss I think of as superior-quality movies.
I don't remember seeing any Herzog films mentioned here (but then it's been 200 +/- posts since the OP), so how about Aguirre. Wrath of God is the English subtitle. It's a tale about a group of Spanish conquistadors in search of an Indian treasure city deep in the jungles of South America, somewhere along the Amazon river. There is much madness, which shouldn't come as a surprise to anyone who's seen Herzog's direction or Klaus Kinski's acting in action before. Comparisons to Apocalypse Now would not be totally unfounded.
Wasn't that one filmed with a great deal of insanity involved as well? I should probably watch that, actually. I've only seen Bad Lieutenant 2 of his movies, and I sure loved that.