Alan Awake. I finally got around to playing it recently and something about the camera movement/placement turned me off. Dead Space has the same issue for me.
Sorta related, I bought Clive Barkers Undying twice (at different stores) without realizing it. One of the copies I left in the bag and stuck it in a closet for whatever reason. It was an awesome game though. I've played through it several times now.
Agreed about Alan Wake. Your character doesn't walk towards the center of the screen, which is really annoying. I don't know who thought that was a good idea.