There is a street in Long Beach, CA, named Ximeno (SIMM-uh-no) Avenue.
Less dramatic is Voorhees (VORE-hace) Avenue in north Redondo Beach.
I know there is a street in San Francisco named Gough (Gawf) Street.
Any other streets with unusual spellings or pronunciations?
Jamacha Road in San Diego. It’s not exotic in the sense that it is from Kumeyaay, the local native language, but the spelling is odd for both Spanish and English: HAM-uh-shaw.
When I lived in North Carolina, We lived on “Kerrimur” Drive. Had fun with that, as it was a brand new street, and we were the first family to live on it. No one believed it existed. Even now, when I searched for “Kerrimur” on Google, the first page of results was nothing but addresses on my old street. I’m assuming, since the neighborhood is called Scotch Meadows, that it is named after the Scottish town of Kirriemuir
Well, there’s Gansevoort st. in Manhattan.
But, my favorite street name has to be Apple’s address:
1 Infinite Loop, Cupertino, CA.
Zzyzz Road, a random freeway exit between So. Cal and Las Vegas.
Chicagoans have been baffled by Goethe Street for generations. And we have three streets that rhyme with “vagina.”
Fuk Man Road in Hong Kong. Great restaurant I like on there, serves ribs.
Columbia, SC, torments new residents with Gervais (jer-VAY) Street and the slightly (to my mind) less confusing Trenholm (TREN-um) Road.
Charlotte, NC, mostly gives people fits for its roads to change names for no reason, or worse, one intersection where two roads meet and they both turn left (or right, depending on which way you’re going).
I sometimes cycle past a road called Azimghur Close.Presumably named after some great exploit of the Raj.
There’s Quaker Street in Schenectady, which is confusing because it’s the name of a town, which has no street named “Quaker St.”
There’s also Dutch named street like Veeder St. and Van Vranken Avenue.
There’s a Chili Avenue in Rochester. Which is not too unusual a spelling but it’s pronounced so it rhymes with sky high.
In Lake Havasu City, AZ there is a street called “Broomrape”
There is an entire section of a subdivision in Elk Grove, CA that has streets named after science fiction writers. [Map link to Heinlein Way]
(A case of a hamlet growing into a town growing into a giant bedroom community so fast that they couldn’t find unique names fast enough…)
Also “Huger,” pronounced “yew-JEE.” It was named after an old family, and that’s the way they pronounced their name.
You can 't beat New Orleans. In one old district, the streets are named after the Greek Muses: Calliope, Clio, Erato, Euterpe , Melpomene, Polyhymnia Terpsichore, Thalia, and Urania.
There is also a neighborhood with names like Arts, Agriculture, Industry, Hope, Law, Treasure, Abundance, and my favorite, Duels, which was then thought of as a virtue of that class…
A street is named after Paul Morphy, the world chess champion.
Galveston, Texas, has lettered streets, too close together, so there is a P, P-1/2, Q, Q-1/2, R, R-1/2. etc.
Memphis has a bunch of streets with the beginning being a name or part of a name, and the end Wood. The two that come to me are Johnwood (where I used to babysit) and Shirlwood.
Now that is cool! (Unless one of them was named Broomrape!)
There is a community near here where several streets are named after notable (possibly local) Olympic athletes, which sounds like a fine idea except that some, fine athletes though they are, have names that are bizarrely unpronounceable.
Also cool, although ordering a pizza to be delivered to Polyhymnia Terpsichore Drive might be onerous. And if your name is Panteleimon Stroumboulopoulos, you may as well give up and learn to subsist on frozen pizzas. 
There used to be a street in Ketchum, Idaho when I lived there about 12 years ago. It was Bobdeaux Street. It was a wonderful bit of local color and everyone was pretty sure how that spelling came about. Someone, when laying out the plat, had conflated ‘r’ for b’.
Anyway, some jerk local government monkey changed it a few years after I left. I never found out why. All the locals liked it. It was unique and funny. Go figure.
Why is “Gough” exotic? It’s a common surname in the UK and Ireland, so I can’t imagine it would be that rare in the USA, given the history of immigration.
New Orleans is the overall winner in the U.S. To top it all off, many street names have unusual pronunciations as well. You make think you know how to say Burgundy and Royal as in the names of two of the busier streets in the French Quarter but, chances are, you don’t unless you have been there before.
Tchoupitoulas (pronounced Chop-a-tu-lus) is a major New Orleans street that isn’t hard to say once you know how to do it but it is fun to watch people to try to figure it out on their own.