I recommend checking out collegeboard.org to do a basic search based on location and major. Then you can add in other things, like tuition. The best school will be the one that meets your needs.
Engineers that work in the automotive industry were typically mechanical engineers in undergrad, I would suggest searching with this major.
Hope this helps!