Pipe on circles/arcs/lines

The inconsistent UV direction across different types of geometry was discussed many times during the years. Here is an example: