Auto ISO can be used in Manual mode, Aperture Priority or Shutter Priority. Many if not most cameras being used today also allow you to set the minimum shutter speed as part of the Auto ISO configuration, which ensures that your shutter speed is fast enough for the situation. I always use Auto ISO when shooting handheld but never use it when using a tripod.