It's hard to get a real impression of what problems may or may not exist, unfortunately.
They don't exactly have a stellar record on this sort of thing.
0 - http://9to5mac.com/2016/05/13/apple-officially-acknowledges-...
This might be a less than a stellar record, but not because of that link.
Internet forums are full of other users complaining of the same problem.
Even if it only affects 0.1% of users, multiply that by the tens of millions, and that's a large number of people having a horrible experience.
It works great for you, until you're in the 0.1% then it's a bitch.
Edit: and it's not just music, it's a mulit-year history of botching up sync across multiple different technologies - some of which I've experienced first hand, some of which I've had friends complain of. Either way, Apple have zero credibility with me and syncing.
Still nothing for the remaining 99.9% of them.
Apple has always done "workgroup"-size sharing pretty well, though. See: early AppleTalk; Bonjour; AirPlay; Time Machine with a Time Capsule; etc. (Though I won't include iTunes Home Sharing in that list; it's garbage.)
But, I was surprised to learn, OSX Server.app is actually supposed to be part of that "workgroup-sized solutions" list, too. It's basically "Active Directory Controller - Home Edition"—an actually not-insane thing to use to manage ~3-8 devices for your family. Stick it on a Mac Mini, forward some ports through your router, set up dynamic DNS and a LetsEncrypt cert, and suddenly everyone can consume regular old CalDAV calendars and LDAP contacts. (Plus some cute other things, like putting all your family's devices under Profile Management so you can push an update to them whenever you are about to e.g. change the wi-fi password, instead of having to go around to everything and change it.)
Basically you open Finder on your MacBook and there's a new sidebar entry: "Desktop on imron's iMac"
</endrant>
Oh No. Please no.
If I had to come up with a list of 5 things Apple is really bad at, sync would be one of them.
I've basically stopped syncing my phone and desktop because of all the duplicated calendar entries syncing creates.
It's something I have absolutely zero trust in them to do properly.