This happens when there isn’t enough physical distance between the two positions of a camera move. The problem gets worse when the keyframes cover a short period of time, and when the transition is dramatic (such as a very fast camera pullback that suddenly becomes a slow drift like you are creating). With bezier keyframes After Effects will do whatever it takes to create smooth transitions between the keyframes, even if that means extending the motion path into a “loop” which is the overshooting you are seeing. Technically it’s correct bezier motion, visually not so hot.
The posts above are good ways to tackle the issue, and you can also correct it manually. Set the comp viewer to “side view” and zoom in to your camera at the time of the movement that is buggy. You will see the loop I described above, along with bezier handles for the camera path. By grabbing the bezier handles and adjusting their length and direction, you can get rid of the motion “loop” and engineer a smooth transition. This might not make much sense unless you are sitting in front of the app and follow along.
Brendan Coots
Splitvision Digital
http://www.splitvisiondigital.com