The problem isn't so much what happens when you are doing the collaboration, it's what happens afterwards. Because NC terms are not allowed in open source materials, your work can't be used for example in wikipedia or in any open source software packages without first getting /everyone/ who every touched it to relicense their part of the copyright in an open source friendly way. If that's just you, then no problem. But often with collaboration this creates a very sticky mess which is very hard to unpick creating many many weeks of work.
This isn't to say NC terms are bad in all cases, their costs are just misunderstood in terms of what the works can't do later. And often times the intent of the owner is quite a bit different to the way the license effects the work in general.
Of course I mean to say that for artwork Nc is fine. Excluding utility works which would be some sort of purgatory with NC