Even Edward Said would not have claimed to be ‘the 20th century’s most celebrated intellectual’. But neither was he ‘Professor of Terror’, says Justin Marozzi