The standing spindle creates relative motion through the rotating worm wheel, while the rotating spindle generates relative motion for the traveling nut. The advantages and disadvantages depend on the space constraints of your lifting system.