Most Americans are optimistic about future trans-Atlantic relations