Peter Eisenman’s City of Culture was born during Spain’s Bilbao-inspired architectural boom. But as the project now languishes, what does it say about the legacy of its eminent designer?