I think the main reason why auto ISO gets the shrug off from some is that it's a feature that not everyone is going to get good use out of due to what they shoot and also the quality of the higher ISO's available on their camera.
If your a studio dweller or a landscaper then auto ISO most likely is a totally redundant feature and that's fair enough, but trust me, it's a damn useful feature for some out there.
I love auto ISO and I'll explain why too!
For studio based or on location portrait shoots, especially involving flash I will always shoot in full manual but auto ISO is extremely useful in conditions that have rapidly changing lighting.
In general circumstances I find it equally as useful, especially when I need to work at the slowest handheld shutter speed I'm comfortable with and I want a specific aperture for effect.
But!.... for figure skating, auto ISO is unbeatable

I imagine that it would also have a serious advantage in
any indoor sport.
From experience I find that auto ISO allows an immense level of consistency between frames and since using auto ISO all the sequences I shoot in figure skating have identical exposure levels, allowing a faster post process under pressure.
Why wouldn't the exposure be consistent during a sequence anyway?
Well, fluorescent lighting flickers faster than the human eye can see, so if your not careful with your set up exposures will vary greatly during a sequence of shots.
This flickering effects white balance primarily but over the last three years of shooting figure skating I can safely say that it also has an effect on exposure, admittedly it is marginal but still, I'll have to slide the exposure level up in post on every third or fourth frame in a sequence and when taking thousands of images in a day you can imagine that that kind of individual attention to an image adds up on the time consumption department.
Shooting in full manual is of course possible, but all these folk that boast about shooting in manual only, as if it's the only way to have full control in any given situation, have, IMO, never been in a circumstance where you simply can't switch between settings fast enough or don't shoot very often under rapidly alternating lighting such as fluorescents.
Typically for figure skating, I set my aperture to 2.8, then set shutter speed depending on the quality of arena lighting, usually around 1/800th or 1/1250th for a well lit arena, around 1/500th to 1/640th for poor lighting and 1/400th to 1/320th for abysmal arenas.
Having an automated variable that does not effect aperture or shutter speed is simply golden

.
The ISO sensitivity ranges from 1000 to 6400 usually and I set the threshold according to lighting quality. Poor arena lighting gets a lower ISO threshold and thus shutter speed will be lowered to compensate.
During competitions, skaters with darker costumes will have around -0.7 to -1 EV dialled in on exposure compensation and around +0.7 +1 EV for skaters with lighter costumes, again the variable being ISO and not aperture or shutter speed.
I also use auto ISO on my D200 to but I will set the ISO threshold much lower as the higher ISO's are a little ropey with that body.
Still, a grainy/noisy action shot is a winner over one than a shot with motion blur.