The Man Utd legend became a laughing stock after enduring an infamous four-month spell in charge of Valencia. So why did it go so wrong?