Two weeks is the legal minimum, yes, but it's a stingy employer that sticks to that and gives you nothing more than they're required to do. I'd say most middle class Canadians get more than that, at least once they're no longer entry-level. Three weeks seems pretty common.
I had four weeks of vacation plus lieu time at my last job, in Canada...the lieu time was time off we got on a 1:1 basis when we worked overtime (in lieu of being paid for that time*). I usually ended up with at least six weeks' worth of time off, plus stat holidays of course. I would have been able to do unpaid leave too if I'd asked, but never bothered with that.
*Possibly part of the trick is to find an employer with a tight enough budget that they can't pay you time-and-a-half, heh...actually, they tried to be generous with benefits like time off just in general, to make up for the midrange-but-not-terribly-competitive salaries there, and have better staff retention. Which is why I know they would have said yes to an unpaid leave request, as long as it was reasonable.
Not every employer in Canada is like this, but they're out there. I'm sure they are in the States too. Possibly more often in certain sectors? I'm thinking community colleges, municipal governments, etc.