Pittsburgh seems to have inexplicably affordable housing -- a lot of it classy old steel-era buildings. And also CMU is there, so the intellectual resources stack up well against any other city.

If you're looking for more of an adventure I would highly recommend Tbilisi, Georgia (ie, the country not the US State). Relatively affordable, great food, culture encourages intellectual pursuits, beautiful country.