Ghost Master, Silent Hill.
I think you have to go on a game by game, genre by genre basis. It works well here, not well there. For example, in a strategy title like Ghost Master you have full control to pan and zoom and survey to gauge your decisions. But in Silent Hill the narrative demands fixed camera views in chosen spots to augment psychological effects and cinematic suspense (for better or worse).