The Pyramids of Giza may draw the most visitors, but magic also lies in the city's historic markets, remarkable museums, and vibrant culture.