if the unit is of adequate power and the
chemical is right, is this a miracle cleaner?

The (chemical) cleaner (surfactant) is still the cleaner. The ultrasonic
energy is just a form of agitation, not miraculous, or even particularly
impressive for that matter.