Pittsburgh is awesome, and I've heard Cincinnatti is very affordable and has an incredible stock of historic architecture and built urban environment. The second tier rust belt cities will have some seriously good value, and great old housing stock.
You can spend some time on here:
www.granolashotgun.com
My wife and I are strongly considering Chicago as well, and St. Louis.