I agree that a lot of the Pittsburgh area falls under the category of "shithole," but there are many great parts of the city that are certainly worth seeing, and yes, in which one can reside as well.
There are plenty of fun things to do in that city. Give than most ND fans enjoy their beer, the brewery tour is something I strongly encourage anyone in the area to try. You won't be disappointed.