CMHC is an arms-length crown corporation. What this means is that they receive no government direction, and they don't, and that they receive little government funding, and they do; so they must be self-serving and self-sufficient, and they are.
I do agree with Mohican over at the Financial Planning Personal Sanity blog, it is nucking futs. But that said, I don't believe this will have any impact whatsoever on the Victoria real estate market. And here is why (Yes, I've purposefully picked the cheapest investment property I can think of):
2-bed 1-bath condo worth $200K with $1200/year property tax and $150/monthly assessment.
With a 0% down mortgage you'd be mortgaging $215K ($15K insurance premium to CMHC) for a monthly mortgage payment of:

Say you're a RE "investor," you take out this mortgage on this dumpy condo, you rent it out for market rates of around $1.25/SF. So you're getting around $1000/month. But you're paying out
$1222 in mortgage, $100 in tax, $175 in MA for $1497 or a $500ish loss every month. Let's say you squeak out a bit more for rent. You won't get $500, maybe $200. That's irrelevant.
The only "investor" for this deal is actually a speculator betting that they'll make their money in inflation and mortgage paydown. CMHC already ate up 7.5% of your inflation (before interest) and considering that condos are overbuilt and already coming down in price (new ones especially) I don't think we'll see too many banks willing to do this deal. So the "investor" will have to go to the alternative market which means they are paying more interest (not to mention that alt-mortgage funds are extremely threadbare with the credit crunch) and their already negative margins just got more negative.
Now this new product may have broader implications in other segments or markets, but in the local Victoria rental pool where rents are barely 60% of carrying costs for the most part, a 100% down mortgage makes no economic sense whatsoever.
Anyone stupid enough to get into this product deserves to lose their shirt when the market corrects. CMHC may get caught holding the bag, but the debtors get taken into bankruptcy first. The premiums that CMHC will charge are designed to make them money. Pure and simple. This is a huge risk that they are aware of; they built that into their business model. In other less-inflated markets, pretty much anywhere east of Manitoba, this product will be a big time money-maker with limited market implications. CMHC is facing increased competition, they got some free advertising today, I doubt if they got much else.