In the Middle Ages, many English towns had a Gropec--t Lane in their red-light districts. (See http://en.wikipedia.org/wiki/Grope_Lane)
If that name wasn't so famous, there'd be some stupidity surrounding it. There's also a Broad Street, a West Broadway, a Broadway Terrace, and at least two streets named Old Broadway on the same island. Also, among picturesque street names in Manhattan, some of which are quite old and which point to history:
Merchant Marine Vets Pl.
Pearl St. (There used to be pearls found along this one, because it was once on the shoreline.)
Water St. (This is a block or two inland, but a block further out than Pearl St.
Wall St. (Named after the old town wall. However nowadays there are walls all over town, so...)
Gay St. (in Greenwich Village, go figure!)
Gouverneur Lane. (what's with the French spelling?)
Gold St. (This is aptly named because it's in the vicinity of the financial district.)
St. Nicholas Ave. (ho ho ho ho...)
St. Nicholas Terrace
New York City started out with named streets. Then they undertook the boring but sensible practice of numbering streets (east-west) and avenues (north-south). Unfortunately, after several decades of doing this, the New Yorkers tired of this and reverted to names (Lexington Ave., St. Nicholas Ave., Amsterdam Ave., and a lot of "Terraces".) Because of that, people might be confused by thinking uptown Manhattan places are in downtown Manhattan.
Some interesting names in my city of Urbana, IL:
-There used to be "High" and "Dry" Streets that ran a block apart from each other (Dry Street was changed to Illinois Street)
-Hollywood Alley runs off Vine Street, so there is a corner of "Hollywood and Vine"
Heard this one today: Preacher Johns Road.
From my parent's neighborhood: Outinda Street, Phire Place and Kurdson Way.