"Rollin' in my 5.0" - Vanilla Ice
"Rollin'" - Limp Bizkit
(the above are very much guilty pleasures
but well, they're about cars)
I also think of a song "The Road Ahead" which was even used for a commercial on TV as well as becoming a big hit around the change of millennium... I'm not sure of the band though. City to City, could that be it?
Also, if you wish to loosen your criteria: "Stripped" by Depeche Mode has the sound of a car engine in the intro...