Two games to look at are Syberia and Nancy Drew. Syberia uses a static view that may side scroll at times. Nancy Drew uses a third person perspective that can pan around a room in the newer games. Both of these turn to third person when they are examining a puzzle. My best suggestion is to allow the story to determine the best camera angle. You might also look at how Shivers was done in third person. Good Luck, Got to Go to Work.