The Dark Knight. The movie is a masterpiece, but the game feels cheap, is poorly lit and has a stupid crane toy shoehorned in purely on the basis of a nonsensical pun.
Haunted House is up there as well; great concept, great artwork, but clunky and frustrating to play.