In good lighting conditions, shooting at 1/250 and f/8 or with more light I usually set the ISO at Auto and allow maybe up to 800, the primary ISO at 200. But, I will choose either A or S mode so as to control one variable. Longer lenses...shutter speed can be set to minimum in the menu. Aperture set where I want it and allow correct exposure to be set by the camera.
In low light conditions, normal or wide lens, I will set my shutter speed (S) at about 1/160 sec or 1/250 and allow the f/stop to go where it needs to, and auto ISO up to about 12,800 on the D4.
When shooting action sports...Manual mode, ISO auto with the shutter and aperture set to what I want.
I think the different shooting venues, wide variety of lenses, and how much motion is desired in the image, make the use of auto ISO just one of the multiple variables used to manage how we control the process.
One important factor in shooting some special images, e.g., the sun through a filter, is to turn auto ISO off as it will tend to cause improper exposure in some of these unusual situations. Also, when one wants a fully manual mode...Auto ISO must be off and the exposure set via an external light meter (yes, some of us still use these) or with the camera metering system.