PERF: increase the minimum number of elements to use numexpr for ops from 1e4 to 1e6
Closes #40500, see that issue for the analysis of speedup vs size.

Another take of https://github.com/pandas-dev/pandas/pull/40502, but hopefully now without crashing the tests because of increased memory use.