Yes, Auto ISO has become more and more viable as sensors have grown better. With slower zoom lenses, using Auto ISO makes a lot of sense. I tried it first in the summer of 2014, and was immediately enthused with how well it worked under tricky shooting conditions. My sense is that Auto ISO's actual implementation differs a bit based on the manufacturer, and the camera model/era, with "some" cameras allowing dead-easy exposure compensation in Auto ISO in Manual mode, as well as "some" camera models/generations allowing upper and lower limits, and in a sense, a more-complete or less-complete set of parameters that Auto ISO will use.
Years ago, like 10 years ago, Nikon's Auto ISO was well behind the system Pentax had developed; Pentax actually had an actual Auto-ISO centric camera control dial position which was designed to allow the user to pick a shutter speed and an f/stop, with the camera automatically selecting the right ISO level; at one time, that system was simply unheard of from any other maker. Nikon basically shifted to that capability, but without the dial-specific exposure mode, just allowing full auto ISO in Manual mode.