No it hasn't.
First. "Turbo" is pure marketing, CPUs never actually see those high speeds in the real-world since the OS spreads work across the CPUs, not just dumping everything onto one or two.
Second. The Pentium 4 hit 3.8GHz in 2004, over 7 years ago. So, no, GHz has not "generally gone up".
The OS cannot magically turn a single-threaded process into a multi-threaded one. Regardless, Turbo Boost also applies when 2 or 4 cores are active, not just a single core. The max turbo rate with multiple cores is lower than with a single core, but still higher than the base clock rate. With enough cooling, a quad core i7 might always run at the turbo frequency even when all 4 cores are used.