I've owned a CTS-V since 2006 and I love it. It beats everything else BY FAR in the same price range. It has everything you want, looks - power - luxury, and it's a 6-speed manual which adds an extra "wtf?" to the mix. The new ones don't LOOK nearly as good as the old model in my opinion and I don't think they have the manual transmission.
Pretty sure they are still 6 speed manual, but could be wrong.