A fan of trashy cult movies, his wacky blockbusters have rescued comic book franchises from mortal danger