I've been curious about this for some time as well railven. I've been wondering why the vsync + triple buffering in D3DOverrider isn't in both driver sets (personally, I have little interest in vsync for fast action games without triple buffering so NV's added hack doesn't amount to much for me).
If vsync doesn't work in the driver options (on the AMD side), and it's a hack on NV's side (with both left with no forceful D3D triple buffering), my question would be why not remove both options in both vendors driver options to eliminate confusion? Some users WILL use the driver options instead of the game options everytime.
With the amount of fanboyism that goes around regarding small features, having both of these integrated into driver sets would help a lot, see this thread for a perfect example when the mention of vsync in NV drivers spurred a circle jerk. Though I'd argue these are not small features, these put the IQ of a PC game on level with the fluidity and solid imaging that consoles have by default.
If PC games are tearing, then when vsync enabled, stuttering (without triple buffering), it doesn't look good and adds trouble to the user experience in a platform that has traditionally fought to stay relevant.
It is true that in-game IQ options are almost always best over driver options, which is why I don't change anything in CCC and forgo D3DOverrider in general.