Now revered as one of the coolest factory cars ever, the CTS-V Wagon was initially quite the gamble for Cadillac.