and the difference is basically that most piggybacks will not be as precise as a standalone and will not come with as many "optional" tricks, i.e launch control,traction control, anti lag etc etc.... although there are some i.e E-manage ultimate ive heard do great things......
You'll find better tunes with standalones obviously providing your tuner knows what hes doing... But they are alot more money....