if you want a camera to be pointing at something while on a motion path, create a "camera with aim", and place the aim where you want the camera to look... putting the camera on the motion path should only animate the camera's translation, not the aim's, so the camera should always be looking at the aim.