Overclockers have already had it running at 9.1GHz with liquid helium cooling, and it potentially offers an enormous amount of processing power if you water cool your PC.
I can't belive Intel even sells these CPUs with thermal paste instead of being soldered. My laptop destroyed it's thermal paste within 6 months, I can't imagine a 300+ watt CPU's paste would survive much longer.
They aren't using paste any more. Since 11th gen Intel's desktop CPUs are soldered, if I remember correctly they use some kind of indium alloy, and so does AMD.
Edit: All desktop CPUs since 11th gen and some 9th and 10th gen according to Intel
Is it possible to create systems that use liquid nitrogen/helium as regular cooling? The videos of LHe cooling kind of required 3 people to sustain the cooling.
You need to continuously supply it with more coolant. I don't know what the thermal capacity of a tank of liquid nitrogen is, but whatever it is, it will eventually run out and you will either need to condense more of it or acquire more from someone else.
You'll need to keep it pressurized or else you'll lose some from it just being in a room that's a safe temperature for you to be in. Even then, you'll still lose some to that when it's allowed to vaporize to dissipate the PC's heat. Unless you use a closed loop system, but you'd still need to dissipate that heat somehow while keeping it under dangerous pressure levels.
Phase change cooling systems can still get quite cold without some extreme liquids. Think like ACs and freezers. You can still get to the point where you need to consider potential condensation with one of those, though a room AC system will still cool your PC because normal cooling depend on ambient temperature.
As I understand it no, not without a large sum of money for a custom solution. They would probably need 2 phase cooling to reliquify the LN2 or helium.