While I also love my 6spd, my feelings are that GM will be pushing this second generation V further upmarket, and will produce more with auto trannies than manuals, eventually phasing out the manual.
They are going to be able to sell more Vs with an auto trans... and have fewer headaches linked to driveline problems (blown diffs, halfshafts, sticking clutch pedals, wheelhop), especially with a more advanced torque management system to control it. How many STS-Vs do you hear about with driveline problems?
And... look at the 08 CTS... or older years. The number that GM produced with the manual tranny is very small. And they still haven't done much to refine the Aisin(?) tranny either, and you practically have to special order your CTS to get one.
Just my gut feeling that, by the 2nd or 3rd year of production, the Tremec 6 spd will be history in a GenII V.
I hope I'm wrong, because it will take me that long to be in a position to buy one and I want to be able to push in a clutch pedal.