Going way back, the old Data East RoboCop arcade game was one of the best 2D sidescrollers of its day. Of course, back then sidescrollers didn't need much plot beyond "walk to the right and shoot everything that moves". It was basically a sprite swap with any other game in the genre, but with better graphics and controls, direct vocal sampling from the movie (a new thing at the time) and the target shooting bonus game between levels.
It seems the rule applies more to games that are timed to coincide with a current film, where the constrained release schedule and whole marketing machine wreck the process. Whereas adaptations based on a setting or with time to develop are better, even if they're not necessarily great.
Most of the Bond games are competent, even if they can't all hold a candle to Goldeneye, because the Bond setting and formula have been inspirations for hundreds of games themselves. The typical Bond plot incorporates FPS, stealth, combat driving, and puzzle solving (mostly via gadgets). You can even work in roleplaying if you wanted to. Yeah, mixing genres usually makes the whole game shallow, but honestly, Bond films in general are shallow (and I say that as a huge fan of the franchise).
The Star Wars setting is so vast and varied it allows for a variety of different games. And it's perennially popular so LucasArts can release SW games whenever they want without always having to time things for a film release. Interestingly, the non-Jedi/Sith games tend to be the best: X-Wing, Tie Fighter, Battlefront and the like. Coincidentally, those ones are rarely based on specific films. Similarly, some of the Indiana Jones games were good. The Emperor's Tomb for PS2 depicted Indy's fighting style extremely well, but was sadly padded during the puzzle-platforming sections.