It was hailed as the chief legacy of the Commonwealth Games - how did the Perry Barr village go so wrong?