I live in the US but my closest long haul airport is Calgary, so I've done this a few times. I don't remember there being a stop on the US side when going north. Canadian checkpoint guys want to know that you're not entering to work. On the return however we usually receive a semi grilling from US CBP about random stuff: did we collect seashells on the trip, for example.