Some of my favorites are Cowpens, SC and a little community in the southwestern corner of VA called Goosepimple Junction.Regina, Saskatchewan was originally called Pile of Bones, but changed it.
And there's a native community, I believe in the Northwest Territories, but I could be wrong, called Sheshatshit -- pronounced exactly as it's written. That caused a few chuckles in the newsroom when they had some big happening there a few years ago.
cheers, ddw