Two-thirds of 1,499 respondents surveyed in recent weeks by Angus Reid said they had an unfavourable view