Here's an article on the
BBC which includes the Sydney/Sydney mistake and some others.
I've heard of people trying to get to Vancouver Washington State (across the river from Portland) arriving in Vancouver BC. However in these days of Passport requirements that, fortunately is unlikely to happen again.