Most Americans see southern neighbor Mexico as having at least a friendly relationship with the U.S. A sizable majority also say Mexico and the U.S. should be responsible for stopping drug trafficking