The first video from the U.S. National Archives, which is the targeted at the general public, gives a good sense of what archives are good for.
Although somewhat amateurish in terms of production values, this video does a good job of explaining how to use the Canadian national archives, Library and Archives Canada.
This more professional-looking video discusses the impressive new home of the Archives of Ontario, which is located at York University.