I have to admit, I had no idea what the Canadian Destroyer was. I looked it up on youtube and I'll be the first to say that that move is absolutely BRUTAL and arguably the sweetest thing I've ever seen. I will also say, though, that that move will NEVER be allowed in the WWE...EVER. The closest thing to any form of a piledriver that is in the current product is the tombstone and after Taker and Kane are gone I don't see any piledrivers, period, in the 'E ever again. Do you not recall Owen Hart vs. SCSA? Austin had his neck broken for him in that match because of a botched piledriver. Piledrivers can paralyze people in a heartbeat and no Superstar in their right mind would allow that move to be performed on them.
As far as Ziggler is concerned, I think the ZigZag is just fine for him. He incorporates the Sleeper on occasion and the Super Kick from time to time is a welcome addition as well.