Construction work is officially completed on the project which is now around £24 million over budget and about four years overdue. So what can we expect from the new cultural flagship?