Hollywood loves a redemption story – just look at Robert Downey Jr. But there’s something equally fascinating about the comebacks that sputter. Depp’s new film – opening quietly in cinemas this week – is part of a bizarre sub-genre of movies haunted and enhanced by the offscreen troubles of their stars, writes Xan Brooks