My dad restores vintage cars for a hobby. He has... A few. And they're all worth a pretty penny, but they're all as moody as they come too XD
It is possible for some cars to be an asset and appreciate in value (you just need to do your research and get the right one) however I dont know anyone willing to part with one once they get their hands on one.