I'm going to try it on my next project. I've done copper, I'm OK at soldering ("sweating") but far from a pro and sometimes I get leaks which is super annoying. And depending where you are working there's a real risk of starting a fire.
PVC and CPVC has never leaked for me but the cleaning solvent and the cement is messy, once you apply the cement you have only seconds to join the fittings, and the fumes give me a headache.
PEX sounds great because you can run it around bends (up to a point) without extra fittings and you don't need cement or solder.