When is it useful?
In parking garages, at apartment buildings and in municipalities where washing with soap on the street isn't allowed. No dirty water runs into the drain.
When not?
When there's lots of mud or sand. A hand wash with water is safer for the paint in that case.
Steam
Some detailers work with steam. That's especially useful for the interior and for stubborn dirt, using very little water.