I worked on a global consumer mapping app once. Among that team, the idea that address schemes were too inconsistent to be useful was also conventional wisdom.

And yet, as I mention in the blog post, Google Maps actually does understand how Vancouver's addresses work. It can find the location where a non-existent address would be if it existed. But for addresses like 138 W 6th Ave it chooses not to, instead trusting... well, I don't know what it's trusting. But whatever it is trusting is wrong, and is resistant to being corrected through the feedback tool.