I think I might be in the minority, but I've always really liked the NES versions of Who Framed Roger Rabbit and Back to the Future 2+3. Roger Rabbit has decent music, fun driving, goofy weapons, and lots of exploration. BTTF also has good music, and the mini-game segments to find artifacts were great.
Good:
Star Wars: The Empire Strikes Back (2600): It's a lot like Defender, but Defender is good, so this is too
Tron (Arcade): All around good game with a beautiful cabinet to complement it
WarGames (Colecovision): It's like a more advanced version of Missile Command
Batman: The Video Game (NES): The music alone is worth playing it
Willow (NES): Nice action RPG in the style of Zelda or Final Fantasy Adventure
Navy Seals (Game Boy): Not super awesome, but a decent side scroller with good visuals
Hook (Game Boy): I haven't played the other versions much, but the GB version is a quality game
Jurassic Park (SNES): Great music, nice visuals, slightly frustrating early First Person Shooter segments
Aladdin (SNES & Genesis): Two totally different games, but both excellent
Michael Jackson's Moonwalker (Genesis): Super weird, hilarious fun. Look it up on YouTube if you've never seen it!
BAD:
Bebe's Kids (SNES): A terrible game for a terrible movie. I have it for cheap laughs, but it's just sad.
No Escape (SNES): Great movie, not so great game unfortunately...
Dennis the Menace (SNES): Another surprisingly great film, but cursed with a clumsy movie tie-in. Mr. Wilson looks like Saddam Hussein