Our shop has been using visualization for just over 8 years, and we're a big fan of technology. I believe that we were the first shop to beta test the product back in March 2005, when it was being developed. (in the current form/feature set) At the time we used Picture It First, but a few years later we switched to FrameVue.
Here is a full comparison list of all known visualization products:
http://www.getthepictureframing.com/gfaq/visualization.htm
As far as I know, our visualization system is exclusive to the area and no local competitors have it. (other than recently with big boxes) We sometimes mention it in advertising.
Do we use it with every sale? No we do not. Probably 50-60%, especially for the new customers or people who can't visualize something that we are upselling. (wider mat, fillet, french line, stacked mouldings, etc) If they're down to two designs, and can't decide, visualization makes it a choice between the final presented design options - rather than a yes or no decision. It does close nearly EVERY sale. Many shops DO use it for every sale, because it records an image of the work (with condition) and prints it on the paperwork/workorder. (and on POS record)
Only one of our front counter computers has visualization. It is connected to a Dell all-in-one touch screen PC, which also drives a secondary 25" LED backlit screen that faces the customer. Only the results are sent to the customer screen, as well as marketing slides when it isn't being used for visualization.
With the proper lighting and camera settings, the color representation will be fairly close. If you're using a picture you took of the samples (versus calling up the mats and mouldings from saved database images), any slight (lighting related) color variations in the samples will also be in the art. We always give a bit of a disclaimer that this is an approximation "digital representation" of how it might look framed, and no one has ever complained. They get it. It's sufficient, IMO, to show them what they want to see - and to make the sale. The samples are right there to see, also, and may look different under their own lighting when they get it home.
Our camera is ceiling mounted, using a couple USB Repeater wires and a power supply. It has never needed a reboot. The software controls the power, zoom, shutter, settings, etc. Most of the supported cameras these days lack electric zoom, so you would keep it fixed to a certain range.
AC Moore and Michaels have them installed, but i'm not sure about the other chains. I believe the big boxes did this in the past year, and you can bet they will soon be advertising it as an advantage. What I notice about the big boxes is that they are using economical webcams, rather than traditional cameras. There is a big difference in quality/result.
If you have any other specific questions, i'll be glad to answer them
Mike