Yes, I'm finding it is common for people to want concurrent access to unmergeable files. Different designers sometimes want to tinker with different rows in a spreadsheet, or different parts of a design doc. Level designers or environment artists might be tweaking different parts of a map, or editing different values on a complex prefab.
It seems to me that talking about better practices is a coder-centred view of things. If 2 coders both work on the same file, we assume version control will handle it safely in most cases. But if 2 designers or artists both work on the same file, we suggest that they're the ones at fault, mostly just because the technology doesn't handle their files as well as it handles ours. If diff/merge didn't exist and we had to replace our files wholesale, I think coders would be less dogmatic about this.
Don't get me wrong - I hate Perforce with a fiery passion, and would choose Mercurial or Git whenever asked. But there will come a time when your artists or designers are angry because their hard work is being overwritten by someone else's hard work and they can't just merge and rebuild like we can.
When I label it a process smell I'm not limiting myself to source control processes -- that's just the tooling we're employing here to work around what's ultimately a tools/formats deficiency: The inability to merge the work in the first place. I'm glad we programmers (and other text-jockeys) have the privilege of very good merge tools, and if others had the same benefit we could all live happily ever after -- Locks don't address the actual problem, they just prevent it by forcing serialization; source-control process too, for the most part, without the ability to merge that work. We fundamentally can't scale up as long as we're stuck serializing the workload.
We should be striving for mergable file formats so that the bulk of changes can be merged automatically, and having that we could view two designers or artists making mutually-exclusive changes for what it really is: a break down in communication. The reality that locking a file in your version control addresses is that certain file formats make the file the smallest unit of granularity that can be reasoned about. Locks might be a necessary, if convenient, evil for the time being and we probably can't make everything lock-free, but they're no less a smell in your version control system than they are in your concurrency-seeking code.
Its not a trivial problem though, that's for sure. Heck, there's not even a good merge tool for XML as far as I'm aware -- indeed the format spec itself makes developing such a tool basically impossible.