Length varies widely with regard to tribe and probably indevidual craftsman. Plains natives seem to make the longest - some more than 1 1/2 feet long. Some southwestern tribes made simple clay and...
if you are smoking it, pipe tobacco is worse, since there is no filter
Also: My vote for the most harmfull would go to the one you inhale. Not that smoking a pipe is without it's own risks.