Exception being those buying new cars, leaving them in storage for a decade or two, and then selling them at auction for 10x.

Even then, it is rarely a good economic decision. Its hard to predict which cars will rise in value that much (unless you're spending $800K+ on some invite-only limited-run hypercar). The storage and insurance add up. It'll invariably need repairs after that time, which can cost a fortune on a limited run car. The opportunity cost will be investing that money in the stock market, which is much more likely to 10x your money.

I'm curious how much you can get for a brand new 2005 Corolla. And don't forget to add storage costs.

Over a decade, that storage space will 10x more reliably than the car