Our Model S Plaid had its active noise cancellation activated through an OTA update a couple of months after we took delivery. We could tell absolutely no difference.
Our 2011 and 2018 Honda Odysseys had/have narrow-band active noise cancellation that is meant to deal with the noise created by the cylinder deactivation for fuel economy. As we can't hear cylinder deactivation when it kicks in, I assume the noise cancellation works well enough.
I'm aware of no cars that have full-spectrum active noise cancellation which is needed to deal with the widely differing frequency ranges between things such as tire noise and wind noise. Lucid experimented with it but found it didn't do much in a car environment, as getting its full effect depends on keeping the ear precisely located in relation to the speaker(s) generating the noise cancellation signal. This is why the most effective noise cancellation systems work best with headphones but, as my experience with noise-canceling headphones on airplanes taught me, even that is only moderately effective.