The technique is most useful when crossing strings at speed with a melodic phrase.
This video shows the difference between sweeping and alternate picking on the open strings (the camera is held) at a decent speed, and then an example with the fretting hand in action playing a maj 7 arpeggio.
