The best is SOS: The Final Escape (It's like a bizarre prototype The Last of Us), and the worst is The Sniper 2 (it's hideously unplayable, but the cutscenes are hilarious:
https://www.youtube.com/watch?v=pNgkpEyoiMI

).
I haven't played Beverly Hills Cop, but I have a feeling it may be just as bad or unplayable as Sniper 2. You have to hit your targets or you face a long loading screen, it's essentially an incredibly stiff and confusing shooting gallery to get to the next cutscene.