So it's just the ends that are really distorted? Have you tried selecting the few faces at the ends, then applying a planar map to them. It might then take a while to line up the texture with the rest