Tim Lee has a great post describing the slow death-by-strangulation of St. Louis by its highway system. The money quote:
Carving up St. Louis with freeways didn’t just undermine individual neighborhoods, it permanently changed the region’s culture. By undermining walkable urban neighborhoods while simultaneously making it easier to commute in from the suburbs, planners effected a massive transfer of wealth from from cities to suburbs. It’s not surprising that many people responded to these incentives by moving to the suburbs. But it was hardly a voluntary choice.
Pittsburgh isn't nearly as chopped up as St. Louis is, and the city is also much more vibrant. However, the Hill district suffers tremendously because 579 cuts it off from downtown.
Though I think it would be much more useful than the North side to downtown light rail line, I doubt 579 will ever be buried. I'm afraid, the Hill districts only hope is for the vibrancy of Oakland to slowly encroach from the east.
Futher East, 376 cuts Greenfield off from Schenley Park and Squirrel Hill. Thankfully, Squirrel Hill is protected from the freeway by the tunnel. I suspect that without the tunnel the entire Summerset development would never have happened. According to Zillow, the average home price is 15207 (Greenfield/Hazelwood) is less than a third of the average home price in 15217 (Squirrel Hill).
Burying a highway is obviously incredibly expensive. The final cost of the big dig in Boston was $14.6 billion! That said, I think it's worth it in many settings. For example, burying 376 would have at least three benefits: First it would add value to all of the homes in South Squirrel Hill and a lot of value to the homes in Greenfield. Second, the retail establishments near Forward and Murray Avenue in Squirrel Hill and along Beechwood in Greenfield would connect and feed off each other. Finally, there would be a lot of new land on top land on top of the new tunnel, much of which is adjacent to Schenley Park that the city could auction off.