Some street names that seem funny to me in my town are:
Major Road - Not really a central road to anywhere where I live, well maybe to the McDonalds or the Burger King, that happen to be across the street from each other.
Sand Hill Road - Connects to Major Road. What makes it weird, is that there is no sand to be found, and it is actually more woods then anything. Also, the road is mostly flat.