Is Germany really the 'second worst' country in the world for foreign residents?

Those thinking of moving to Germany may have been given pause by recent headlines stating that the country has been ranked second-worst in the world by a large survey of people living abroad. Is it really so bad?