The Salford border is being touted as Brooklyn to Manchester's Manhattan. But, as Neal Keeling reports, there are problems that can't be solved by shiny new towers