Seriously dude there's only so much advice that you can get... no matter how many questions you ask or topics you post, the substance of the advice you have already received is not going to change. To sum up the answer to your question: it does work better than vsync+triple buffering but it's also just a marketing ploy for most people.
Just re-read that thread replacing "vsync" with "vsync+triple buffering" - the advice doesn't really change.
Sorry I didn't make that clear - triple buffering helps alleviate the negative affects of pure vsync but cannot do so entirely in the way that adaptive vsync can. Triple buffering is probably why I had minimum framerates of 40 and not 30 in BF3, but if I had adaptive vsync, my minimum framerate would have probably been the usual 43-45.
I personally do not use adaptive v-sync as it doesn't work well with 120hz. Even when I'm pinned at 120 FPS, it will still not turn on v-sync and I end up with tearing. I'd also rather have 90 FPS with v-sync on than 100 FPS with v-sync off.
Adaptive isn't useless at all. When it works it's a perfect solution, turning off vsync when fps drops below monitor refresh rate and turning vsync on when fps goes above refresh rate. Some games for me it works perfectly. Other games it's not consistently turning on vsync above refresh rate so I still see tearing. Nvidia still has some work to do to perfect it. It certainly isn't a marketing gimmick. All anyone has to do is read about the technology to see that it's real. Hardocp has an excellent article on it.
I personally dislike it, as I hate seeing tearing when below my monitor's refresh rate. This is especially true when using a 120hz monitor. If you dislike tearing less than I do, and have a 60hz monitor, it may have some use for you.
As far as triple-buffering goes. For the most part, triple-buffering is only an option for older OpenGL games. The control panel option only works for OpenGL, and only a few games give you the option to turn it on or off in DirectX, which the vast majority of games use. Most games have it automatically built in.