For me, it has to be Alien: Colonial Marines as it’s terrible due to inconsistent frame rate (moments the game ran smooth and times where lag was insane, even with the best hardware). Both player & enemy AI is crap since the combat wasn’t even that immersive plus Xenomorph AI isn’t as intimidating due to it being poorly implemented.
it’s still crazy to me how good Spider-Man 2 was back in the day. because of that and the original GoldenEye, I have forgotten any bad adaptations as well.