The CPR overflow requires more maintenance than other overflows and also requires a powerhead or airpump to operate. The continuous siphon created by the powerhead or airpump means that there is one more element that could cause the CPR to fail and cause a flood than the U-tube style overflows have. The CPR is also a lot more difficult to clean than other overflows. If you can live with all of this and keep up with maintenance, the CPR can be a decent overflow.
I've used both, and am currently using a CPR. I've got an Amiracle overflow sitting in my closet that I plan on using for a future setup, but it just wasn't giving me enough flow through my sump on my current tank.