I don't think they lived up to the hype. I remember they would get clogged all the time. Most places that I recall having them returned to regular plumbing.
They're all over the place here in Australia. Personally I don't think I've encountered anywhere that's switched back from them. It's also very common to see traditional plumbed urinals converted over to waterless.