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.