Used and still have the original version for the LGA 1200 socket. The issues there were not so numerous, the biggest one was the noise from the unit. It was almost, no it was unbearable and CM acknowledged that.
The purpose of this cooler is for opportunistic sub ambient cooling, where you can increase frequency for lightly threaded tasks and perhaps hold all core Turbo frequencies a little longer than otherwise possible. It does not however allow you greater clocks for your full load OC. The TEC simply can't handle that. CM could make it so, and in fact the unlimited mode on the older generation allows this to some degree, but realize you are using 300W or so just for cooling at that point.
As for software, unfortunately this sort of cooling does need intelligence, because it needs to avoid condensation (which is does exceptionally well), balance power draw and control temps at the same time, without user intervention. Issue is ramping up the cooling when required, and scaling it down when it's not, quickly enough.
This is a high end cooling solution, but purely because of physics limits when dealing with TEC units, you'll get the best results from 13600K or something like that where the TEC can better cope with the thermal loads. My current 13600K is limited to 5.5GHZ all core Turbo, but with this unit, I could realistically push 5.6GHz (dialing in a greater negative offset on my V/F curve) and perhaps 6GHz on lightly threaded tasks.
On bigger CPUs like the 13900K, it is less useful and restricted purely to lightly threaded work loads as even a full 8P load without E cores would be too much.