On TRINET there had been a discussion on metropolitan areas that overlap multiple countries. Someone posted this wikipedia page for a fairly comprehensive list:
https://en.wikipedia.org/wiki/List_of_metropolitan_areas_that_overlap_multiple_countries
I have been to a few of them, most notably Niagara Falls.