I've driven a couple of the CVT nissan's from Hertz etc while traveling.
They are kind of neat, but I'm not entirely sure how great they are. Gas mileage didn't seem all that good. Of course part of that is, well, it's a rental, with a CVT, soooo everyone that rode with me, or drove one, wanted to floor it cause it just sits on the redline while you accelerate.
Not really "optimal" for mileage.
But they do have good pep, and seemed more responsive than a lot of normal automatics I have driven.
I also agree with Rich about the DSG's being awesome. I'm still bitter they didn't stick those in the TT's until the year after we bought one.
Also
http://en.wikipedia.org/wiki/Continuously_variable_transmission
Has some interesting info about the history, etc.
And to Matt, yea. that's why everyone floors them at first. it's REALLY weird.
At least it was to me for a few days. Then I'm back in the jeep, and well, nothing in that is "smooth" sooo, next time I travel it's all new again.