I didn't think I would use it much either, coming from a Digital Rebel (300D), I'm used to ISO 400 and 800 being pretty much worthless. The high ISO images from the 40D are far from worthless, so I'm very OK shooting with those ISO's.
Anyway....I decided to give it a go, and I like it. I went to the zoo with the family and kept the camera in "P" mode with auto ISO. I was pleased with being able to shoot in doors, and out doors with out changing a thing on the camera.
It is interesting watching the ISO numbers dance around more then the shutter speed and f-stop, at least it seems to.
Its also nice that "Auto" is one stop away from ISO 100. As of now, I think these will be the two settings I use the most.