Largely positive results, unless you're beyond 120FPS.
Alternatively, this will push for a higher demand of in-game support with native FPS capping options. A big win in and of itself for the fact that those without G-sync will benefit by not having to run V-sync and allow the graphics engine cap the FPS natively.
One issue is the lack of capability with Lightboost or UltraLightboost.
Also, the limited-time kit is $200 from Nvidia. It also doesn't support audio via the cabling (I doubt a large issue since most gamers don't use their monitor's speakers, but an important note).
Except vsync eliminates tearing and frame rate limit, even if it's set to the refresh rate, can and does tear. Vsync isn't simply a refresh rate FPS lock.