We added this feature in Photoshop CS5. With the Zoom tool selected, start the zoom by clicking on the area you want to zoom into and keep the mouse button down. As you drag right, you zoom into the point where you initially clicked. As you drag left, you zoom out from the point where you initially clicked.
Not all users like it though, that's why it's an option that can be turned off: