I don't think you understand the Lamborghini brand proposition. Obviously the cars are just a brand of the VW group with Audi or even SEAT parts beneath the bodywork, however, the heritage is not what you describe. Mr Lamborghini was a self made entrepreneur and he was viewed as some peasant of a tractor manufacturer by Mr Ferrari. So when he made his own car he made them for self-starters like himself. He had no heritage to play on, didn't go racing and he wasn't a snob.
Meanwhile Ferrari chased the stuffy old money, the old people that didn't have Lamborghini 'larger than life' style but neded the proverbial male body extension. So long as they were the right class (upper) Ferrari was okay to sell to them, he didn't want to see 'common scum' like Mr Lamborghini driving his creations.
Although VW have done great things with the Lamborghini brand and made the cars desirable to those you disparage, the fact that so many parts are shared with Audi and even SEAT cars changes matters when it comes to parts availability - you can get them.
As for those Ferrari cars and what the brand stands for there is a lot to take on board. The Formula 1 side is still a mobile billboard for fags, even if the 'Marlb*ro' logo is subliminal in the West, in developing markets this sponsorship deal is selling the coffin nails nicely. Then there are the chintzy theme parks and the toy/keyfob business. I know everyone has an inner nine year old to appeal to but I don't see how Enzo would have liked this distraction from the racing passion.
As for the resale market and this matter of appreciation in prices. Ferrari are a glorified 'Franklin Mint' these days, it is all about artificial scarcity. The Ferraris that have real value go on the track at Goodwood and Silverstone - doing so is very much part of the pedigree and they do get bashed about a bit. A 1960's 275 or other icon of the brand sees the track and has storied heritage - the people that drive them being real drivers. New 'designed for speculator' Ferraris might appreciate but they don't have intrinsic historical value. People in the Arabian Peninsula and the United States who have more money than taste buy them for the garage and never drive them to the edge in order to win a race.
Technologically the cars have also lost a bit of the lustre. The whole business was based on selling V12 engines which no longer works. If it is petrol power you want then the McLaren cars have the race winning innovation these days whether in the engine bay or the carbon fibre tub. Take away the prancing horse and the design isn't iconic really, on a scale of one to 'Testarossa' a modern Ferrari is nowhere near.
I am not sure that owning a vast quantity of Ferrari cars gives someone a particularly unvarnished viewpoint. Taxi drivers think the Prius is the best car ever for monetary return on investment but that doesn't make them experts.
For a long time antiques were a good investment, people sold them in rings, the things forever going up in value. Then IKEA came along and fashions changed - chintz was chucked out. The problem with the not-so-classic car market (recent supercars) is that four door saloons from the Tesla company provide the instant acceleration thrill that is so much more appealing than noisy exhausts. There is major danger that once EV takes over nobody is going to be interested in the heritage-less garage queen cars that were only bought by rich people for investment potential. You won't be able to drive them in cities due to emissions, so they won't even have utility value.
Anyway, good on the Lamborghini owners for living the dream that Mr Lamborghini innately understood.