Some people have mentioned Half-Life 2, and I like the Uncharted games, especially the second one, for much the same reason: they break up the shooting with lengthy non-combat sections, whether it be puzzles, platforming, or just getting to walk around and soak up the atmosphere and the view...