I don't think it's a cable-only issue, at least not for me.
I have two Hondas, a 2008 & 2019. Neither have a wireless CarPlay option and both have USB-A sockets.
iPhone 14 worked fine in both.
My new iPhone 15, is intermittent at best. It will connect about 30% of the time, and even when it does it will sometimes disconnect. So if it was a cable, I would think my experience would be different.
Regardless, I have tried several types of cables, including cables bought from the Apple Store, all high-quality.
I am not happy about this, at all and if I hadn't already turned in my old 14, I would send this back.