It's closer to a cousin you used to be close with despite some moral failings, but who has now has a substance abuse problem and is lashing out at family and friends.
Eh, that's pretty misleading: in that poll, Canadians weren't asked for an adjective to describe America, they were given a list of three options “Ally/Neutral/Enemy”.
Not an enemy, just a danger.