The trick with good texturing is to visually identify patterns within texture(s) and finding better matches within geometry similarly identifying patterns in geometry, like a trim block in texture to match a strip of polygons forming up a line or a curve in the mesh (borders in cockpit, bevel/emboss borders, etc). Ideally arranging these patterns relatively uniformly and avoiding mapping distortion between uv projection and geometry shape. It can be further improved by smart use of uv mirroring so as to repeat pattern in texture back and forth and making a seamless loop, this is particularly common trick in dealing with cylinders and geometric strips that loop back.
