Lots of states do this... NC is just one of them. You pay a reduced "highway use" sales tax (3%) at time of purchase instead of the full sales tax you would in say, NY. In some states that do this, you pay a tax but it is capped at a specific dollar amount depending on class of vehicle....When I lived in SC and bought a brand new truck, my sales tax was capped at $300 (back in 1998)...
If you are one that keeps your vehicles a long time, then the yearly personal property tax fee on the vehicle gets pretty low. I was paying $59 a year the last couple of years on my old Dodge Dakota which I had for 13 years. The tax bill I get next year on the new F-150 is going to hurt.

If you are the type that has to have a brand new shiny vehicle every 3 to 5 years then you are going to end up paying a lot of tax over your lifetime just on vehicles.
Incidentally... If you have a toy hauler in NC and it is based on a cargo trailer, make sure it stays titled as cargo... cargo trailers pay a one time tax, not yearly.
Taxes are still less down here overall then in NY.