If you were to visit the city two months from now, it would look completely different. When you are just visiting, and the winter greyness is still in full effect, those buildings are definitely gonna look aged and old, especially in most of Oakland. Otherwise, Pittsburgh has aged (overall) astoundingly well. In terms of beautiful buildings/architecture, it's no Boston or anything, but it's definitely a city with architectural character, and not in the sense of "character" where one means "ghetto."
See some good pics here http://www.virtourist.com/america/pittsburgh/pittsburgh_photos.htm
And while 600 for a two-bedroom is pretty darn good, $700 isn't a surprise at all, but more the norm (excepting Shadyside and fancy/schmancy places).
There are plenty of beautiful women in PittsburgH, too, just don't expect them to have lovely speaking voices.
Where are you from, Mahoneit? It would be unfortunate if one visit deterred you from a city adored by almost all who have lived there.
Hope those pics help a little.