A couple of weeks ago, I went to our office in Cairo for some training. Not a bad gig to get to visit Cairo on the company's dime. Having been there, I can now say that seeing the Pyramids was a nice life experience, but I don't feel compelled to return. The city just isn't very tourist friendly, and I think it's because they know people will come anyway.
I've lived in Southern California, and I've been living in Almaty, Kazakhstan, for a couple of months. Both of these places are well-known for the amount of traffic and pollution they have (but LA is much better than it used to be). I don't think that together they add up to the amount of traffic and pollution that you see in Cairo. Even at 8 in the morning, it was nearly impossible to see buildings more than a few blocks away. And if you're not confident walking in traffic, you'll never cross a street in Cairo.
However, I did take a day trip to Alexandria, and it was much more pleasant. On the train up there, it was interesting to see the small farms along the Nile, some with mud houses that looked like they had been built 1000 years ago. Unfortunately, there wasn't much time to explore Alexandria, but there was an interesting castle (there's a picture in the post below) that was built more than 500 years ago, and the ruins of a Roman amphitheater.
I'm not one to say that seeing a famous landmark like the Pyramids on TV or in a movie is an acceptable substitute for seeing it in person, but my opinion may be changing. Television and movies seem to do a better job of presenting the Pyramids in a way where the viewer truly regards them with awe. In person, all the scammers bothering you take that feeling away -- along with a big chunk of your money. Visit Istanbul instead.