It depends, Ferrari dealer can easily perform the "Ferrari Approved" inspection then slap on the 2 years CPO warranty to attract much larger buyer pool even at high premium. Not to mention the access to Ferrari financial services which is totally private. It appear SF90 pricing is kind of stabilize now as the dealer also jumping in on the deals.
Very curious to see where things go. Hopefully pricing stabilizes a bit. I love my '23 but a 50% depreciation in 2 years is disappointing. It wasn't purchased as an investment at all but I like to go from one to the next (I have a 12cilindri spider, a puro and a speciale A on order) and the trade in will be painful...
12 Cilindri Spider is something special NA V12 without hybrid and as a Spider is virtually non-existent among other manufacturers. We'll have to see how the other models you mentioned are going in value. It's difficult to say, but anyone who really wants a car with the best performance and a V8 now has the chance with the SF90. Don't forget that the 849 Testarossa with some options is 250K more expensive, which is a lot, you could buy a used F12 or a 458 for that additional.