Rockstar's The Warriors and Volition's The Punisher are probably the only two decent film licensed games I've played.
Their saving grace (apart from being made by great development studios) could be the fact that they're tenuously linked to their respective movies and not a cash-grab tie-in, with The Warriors being based on an old cult classic and The Punisher being just as much based on the comic books rather than strictly based on the film.
Both games seem great because the developer wanted to make good games based on those characters and stories, not because the studio decreed that a game, any game, be made to coincide with the films.