Do SIMD optimizations have an effect on JOIN performance?

Yes, if the SIMD optimizations are done on the JOIN operators. However, this optimization can be done on any operator, so it is not really JOIN specific. This is why we are faster than Java based DBs, like Druid and Presto. (or actually why CH is faster than Druid)