I have yet to drive a car w/ a CVT, but the idea just sounds neat. However, if you're considering a car with a Borg Warner CVT unit, buy it! (um, yeah, I own the stock, so?)
Seriously though, my bro is looking at a bunch of 5 door hatch backs, and some of them have a CVT, as much as I think the tech is neat, it makes me nervous.