It depends on your specific property, your cash at hand and your goals.
CMHC is insurance for the bank, paid for by you, the borrower.
It may make sense to pay this fee to lower your mortgage interest rate or to get the deal with the available cash .. or it may not.
Your question is too broad. More details are required !
btw: it is "through" not threw !
Do you want to buy my used Lexus ? It is only $12,000 ! Is this a good deal ?