> I know there are workloads when it actually can hurt performance, but are they more common than ones when it helps?
Hyperthreading makes better use of execution units but causes twice as many threads to share memory bandwidth and caches. It's often a good trade-off.
But it's also less valuable for high core-count processors, because workloads that aren't highly parallel will have idle real cores to run other threads on, and highly parallel workloads are more likely to be bottlenecked by memory and caches when there are more cores.
The real question is whether it's faster for your workload. And your hardware. The answer could be different on a system with 8 cores and 2 memory channels than a system with 4 cores and 4 memory channels.
Turn it on and then off and see which is faster for you.
Sure, but if it's a feature that's increasing performance without a bug, it's something that should be fixed, otherwise you are paying for broken hardware.