Twin clutch (DSG) transmissions are the trans of the future. That's where the industry is heading. A different division of the company that just laid me off has one in production and another one close behind.
They are like two manual transmissions with two clutches. One clutch is driving one gear and the next one is right at the point of applying. It's much more complicated than an automated manual trans, but they do work well.
VW/Audi has had them in production for several years. I don't know how they do on durability, but I haven't heard any bad news, if that's worth anything.
CVTs came and are leaving. I think there won't be many more in the market place. Ford already dropped theirs after three years of production. They are essentially a revved up snowmobile trans, but how would a Floridian know about snowmobiles?
I owned one in a 2005 Ford Five Hundred. I really liked it, but wife wrapped the car around a tree. It took some getting used to because the engine doesn't rev then drop in RPM at a shift and rev again. It just goes to one RPM, which is around peak torque RPM, and just sits there. The trans ratio changes as the car accelerates to keep the engine producing at peak torque. It's great in theory, but the belt is a problem. Ford/ZF used a metal belt that durability testing showed held up very well.
Efficiency is their strong point, though in the Ford application the same car with a six speed auto got one MPG better fuel economy. I believe that was due to poor programming on the CVT. My CVT left the torque converter unlocked most of the time. I would have kept it locked from shortly after launch and adjusted the trans ratio to compensate. That should help efficiency quite a bit, but it might have compromised smoothness.
The Five Hundred had a 3.0L engine, which I believe was the biggest engine ever offered with a CVT. Nobody has been able to make one work with larger engines. The belts have a very short life with larger engines.