Cars that were considered only good for scrap are worth $10k today... its crazy. Not many people saved Brats and thier uniquness means they will always command a bit more then an average vehicle. Only ones in perfect condition get real money, most nice ones sell for about thier original MSRP and ones that are rusted (I assume that is most of them) are only worth 1/2 that. Guess that is still pretty good for an old Subie.
Those older Mustangs were super popular from the get go. The El Camino was unique in being a muscle car + truck. Both of these vehicles are considered collectable now because they were hot ticket items back in their day and were expensive in the rare configurations that became collector items. They were cars all the cool kids wanted, but nobody is putting posters of SC on thier wall, they just aren't that desirable. The SC was only hot when production first started and there were hard to get.
All the SC has going for it could be the first in the current generations of truck based CUVs. However with the EV rush I'd say a Rivian has a much better chance of become a future classic. Its not like Ford Sport Tracs are worth alot these days either. Give me example of collectable Hyundai. Even Hyundai's first RWD sports car, the Genesis hasn't gone up in value a decade later.
Barrett Jackson has made people think everything is some highly desired collectable. I had a 2003 350Z and its
worth only 20-60% of its orginal value (depending on model and condition of course) after 20 years and I think everyone would agree the Nissan Z has a much stronger and more loyal following then the SC. Maybe in 30 years original 350Z values will go up when the idea of V6, RWD, stick shift sports car is considered "vintage".
Also limited production does not equal valuable, because owned a Volvo C30... they were not desireable back in 2007 and
still not desireable. Sure you can cherry pick a few vehicles here and there but if your holding onto the idea that an '22 SC will somehow hold its value over the next 10 or 20 years I've got some dry land to sell to you in the Everglades.