My favorite name collision is Ontario, CA (city, state) and Ontario, CA (province, country).
Saint John NB and St John’s NL is one I find endlessly funny. On paper it should not be a collision, and even out loud it really isn’t one, yet I know multiple people who have independently flown to the wrong one.