Not sure why you would need to pay for Apple CarPlay ?
I comes free with your iPhone.
The USB cables can be hit and miss, both for AA & ACP.
In our 2018 we use this
https://www.amazon.com/Carlinkit-Wirele ... B0CS2QS56K
to make it a wireless connection.
Online reviews are mixed, but it served us well the last few years.
iPhone SE and now 16e, and various Android phones.