io9 has a great list of 100 unmade films including Jodorowsky’s Dune, Terry Gilliam’s Watchmen and (my personal favourite) Beetlejuice Goes Hawaiian!