My favourite was one I came up with for a city I built in the desert for the purpose of accessing iron and clams.
Ironclam Flats.
Myself. Yes, I've named a city with my own name.
Filmore, Gapston and Plugworth for late-game infill cities, Igloo and Icebox for arctic landgrabbers.
Penzance seemed appropriate for a city at the far south-west of my continent.
Marblewine was self-descriptive and euphonious (and KMadCandy built "Pig Iron", also self-descriptive but less pleasant-sounding)
I usually leave the names the game has preassigned for the Civs...but I was getting used to a new keyboard and kept missing the enter key....I'd hit the ] or \ buttons as I was plugging at it....
So I ended up with Munich, Munich\, Munich], and Munich\\
I was pretty confused as the game went on.
mumbles ive never heard of a place calleed mumles!!
I'm boring and tend to use default names, but when I capture a barb city in civ4 I give it a insulting and humorous name - f.i., Uzbek was renamed "Major *******s", in memory of their early raids into my territory.