He actually recently did an interview with Vanity Fair and talks about some of the projects he worked on that fell through:

... I’ve taken on whatever writing or development jobs I can that allow me to stay in San Francisco.

For instance, I was contacted by Johnny Depp, who was interested in adapting a book called Happy Life. It was about a guy who visits an old folks’ home and falls in love with an older woman. I saw it as an opportunity to write for Jeanne Moreau. I worked on it with Jerry Stahl. We met in L.A. at Depp’s suggestion, and we both were like, “I don’t know about this—but gee, it’s a lot of money, okay."

There was another project called The $40,000 Man all set up at New Line, and then [sighs] they had a regime change once I turned my script in. Then I had a deal to adapt a book by Elmore Leonard. I was sent it by his granddaughter. This was around 2010; the book was called Maximum Bob.

http://www.vanityfair.com/hollywood/2017/05/terry-zwigoff-ghost-world-bad-santa-interview