My favorite confusing street I've dealt with is Boulevard in Hartford, CT[1]. Often abbreviated, so addresses like "1600 Blvd" are common. And of course there are streets where "boulevard" is the last word in the name, like usual, to add to confusion.

[1] https://www.openstreetmap.org/way/1091898993