My favourite street name has always been the one in the city I was born in and live nearby to, which is Avenue Road. Because it's so pointlessly generic.
Wow. Do the people who name these just suffer critical imagination failures, or are they doing it on purpose?
You can tell the exact point where the old cartographers in Utah started to get lonely, because you start getting names like "Nipple Butte". Also, in terms of weird names in the Southwest,
There's a town in a province in the Netherlands (where I live) which is called 'Sexbierum'. I'm sure you can guess the translation, but it's: sex beer um :P