The standard uv map for a spherical/semi-spherical mesh is a planisphere projection, that will automatically wrap the texture along the longitude edge loops. It is like that on your Valvoline example and it looks fine imo. You can go around that wrapping by tweaking the texture, but it won't look good even if you do it right; in real world they rather use blimps to display ads without distorsion.