
My favorite movie tie-in game is Goldeneye (N64). Of course, this game was good because Rare was actually trying to build a good game with the theme of the movie instead of just making another piece of merchandise to go along with the Burger King Kids' Meal toys. (There were no such things for Goldeneye, but you get the idea about how licensed games usually turn out.)
My least favorite is probably every other movie tie-in game I've seen.