If you’re looking for iPhone 15/iPhone 15 Pro and CarPlay compatible USB-C to USB 3.1 Gen2 cable, you might want to try Anker PowerLine II cable.
I happened to have a braided Anker PowerLine+ II USB-C to USB-A cable that I bought back in 2018; which is no longer available for purchase. It works with iPhone 15 for CarPlay; for CarPlay-compatible automobiles that are still equipped with USB-A port.
I also have some other USB-C to USB-A cables. Almost all of them are not CarPlay compatible as they are primarily charging cables; not for data transfers.
I just received Anker PowerLine II USB-C to USB 3.1 Gen2 cable; it works with iPhone 15 and CarPlay.
I’m ordering a few more cables to test if they work with iPhone 15 and CarPlay.