While in the youth hostel at Rowardennan recently on a hill-walking trip, I came across a tourist brochure and decided to have a look. A little place near the north shore of Scotland caught my eye and caused me to snigger regularly for approximately 3 days afterwards.
This attraction, the largest coastal cave in Britain, is called "Smoo Cave". It's even got a website.
Post your own local (or non-local if you prefer) stupid placenames, and link 'em if you can.
For the record, the longest place name in Britain is not the oft-quoted Llanfairpwllgwyng˙llgogerychwyrndrobwllllantysiliogogoch but is actually another Welsh village, Gorsafawddacha'idraigddanheddogleddollonpenrhynareurdraethceredigion. I have a photo somewhere of me standing next to the sign at the train station (obviously taken from a distance ).