The most common — and most expensive — misunderstanding is assuming that "water damage" is one thing your policy either covers or doesn't. It isn't. Canadian home insurance treats water as several separate perils, and the two that show up most in flood season are usually optional add-ons you have to buy by name.
Overland flooding — water entering from outside, over the surface, from rivers, heavy rain, or snowmelt — is typically not covered by a standard policy, though many insurers now offer optional residential overland flood coverage for most homes, priced on risk, according to the Insurance Bureau of Canada. Sewer backup — water pushing up through drains during heavy rain — is a different endorsement again, also usually excluded from the base policy. And a "comprehensive" or "all-risks" label doesn't fix this: those policies can still exclude flood and sewer backup as separate purchases, and predictable events like the flooding of a home built on a floodplain may not be insurable at all.
In areas carriers classify as high-risk, even where overland coverage exists it may be capped, carry a steep deductible, or be unavailable entirely. That's the practical face of the affordability gap: not a line in a budget document, but the terms you're quoted when you ask. It's also why home policies in exposed regions are trending toward $10,000 deductibles and coverage pullbacks.