I would be most grateful if someone can correct me if I am wrong in that the only difference between Apply Curve Piping Vs Normal Pipe is that the former is not an actual object until it is Extracted compared to the latter?
I suppose you could put it that way. Do note, though, that when you extract the piped curve it will be a mesh object as opposed to the regular pipe that will be a NURBS object.