VBA is single-threaded "by design" meaning: it's designed as single-threaded. Excel has one process for VBA interpreting. There are some more or less complicated workarounds but nothing usable at work.So, to summarize, you need higher single core performance and fuck multithreaded because:
1) your "single threaded by design" CPU heavy VBA code that you regurarly execute runs faster
2) you code some perf heavy stuff that you regularly execute
Correct. What's wrong with that?
As I've said: I prioritize single-threaded performance because of the tasks I perform.
3) last but not least, because there is laughable article on the internet that checks how much faster an image file is read from an USB drive, with more cores
Laughable because?
Puget Systems is an acclaimed custom PC building company and I have no reasons to discredit their analysis - especially since I've seen similar results both on the web and in my work.
Yes, importing files from a USB drive is limited by the drive speed, but they tested it anyway. Why?
a) Because the purpose of the article was to go through a typical workflow and importing files is inevitable.
b) Because testing things that seem obvious is very important (also in more scientific problems). From time to time you'll actually get some interesting (unexpected) result.
Example from the text (which I've mentioned earlier): RAW->JPG conversion is fully parallelized (using as many cores as it can), but for some reason RAW->DNG doesn't benefit from more than 4.
Did I miss anything?
Possibly the fact that you asked me why I value single-threaded performance more and that's what I've been answering. However, you seem to think I generally underestimate multi-threading, which is not true ("fuck multithreaded performance").
Multi-threading is very important in many computer tasks. I'm just pointing out that single-thread performance is more fundamental. There will always be some tasks that only utilize a single thread. Even if at some point in the future CPUs will have hundreds of cores (e.g. CPU and GPU will be unified), single-core performance will have to be on an acceptable level.