My family (mom, dad, sister, and brother-in-law) and I ventured into Canada yesterday after staying in Buffalo on Saturday night.
We went prepared w/ birth certificates/passports, but were not asked for any identification of any kind. The Canadian border was easier - we sat in traffic for the US border for ~1 hour.