We are U.S. citizens and wish to enter Canada to see Niagara Falls from the Canadian side. Do we need passport books or will passport cards be sufficient for this purpose?

Yes you may use/purchase passport cards for all land travel. They can be used/purchased instead of the full passport.