This is your favorite auto museum
So wait? Cars or just transportation technology in general? Because that makes the difference.
If transportation in general, I would say USAF’s National Museum at Wright-Patterson AFB. Some really cool items there, including the world’s only Valkyrie XB-70, one of the few remaining B-36s, and their Air Force One collection, which is a great visit.
If Cars specifically, I would call the Automobile Museum in Auburn, IN. And the amazing collection of Auburns, Dusenbergs and Cords.
I’m counting planes, trains, and the rest of the transportation world here. You could make the argument that the Space Shuttle, from my proposed Air and Space Museum, isn’t technically a “car”. Of course I would retort, “That’s the damned Space Shuttle. Isn’t that great for you?