Not only zooming, Google Maps also has search. If you're looking for Oakland, CA, you go to the search bar and type "Oakland, CA", and it shows up on the map. No need to scan the map for the thing you're looking for, that's the computer's job!
I guess the main complaint of OP is not about finding a particular location, but to create a mental map with the area of concern. To create mental map efficiently, the map has to show large enough to cover the area of concern, yet has to show enough landmarks to associate with. It's crucial to have both information simultaneously in a single sight---if you have to do something to see one information at a time it becomes very inefficient.
That said, I suspect that there's a fundamental difference of processing maps among people; I like to store a map in my head and trace mentally. When I drive, I prefer to see the map always north up, so it's easy to synchronize with my mental map. However, most car navigation systems orient the map as your direction---I find it very uncomfortable, but apparently that's most people want.
I really wish someone would add an east-is-up mode, since that's the traditional orientation for maps — and the root of the word 'orientation' to begin with.
Because the sun rises in the east. At least in Indo-European cultures, which were once reliant solely on agriculture and transhumance, the sun was extremely important. Without a compass, it's also extremely convenient, being the easiest celestial body to spot. As such, ancient Indo-Europeans stood facing east when performing religious rites. The reconstructed proto-Indo-European words for "north" and "south" are also the words for "left" and "right" respectively, because the north is to your left when you're facing east, etc.
I was going to a location yesterday that you couldn't search for. "The junction which splits the road going to A and B". I was very confused by the new Google Maps which essentially didn't show enough detail for a good overview and orientation.
Search is of course entirely useless, worse than useless, if you don't know in advance what you are looking for. Needless to say, search is not an adequate substitute for intelligent design and proper levels of detail on maps.
Can you explain your use case here? Normal Google search is great for finding the name of films you can't remember by typing vague descriptions of the plot. Maps has similar functionality, like "local coffeeshops" or "<business> in <city>".
My technique: When I'm in an unfamiliar city, I search for restaurants and then looks for clusters. When you see a cluster of restaurants, this tends to be a downtown and is usually somewhere 'interesting'.
> If you don't actually know what you're even looking for, NO MAP whatsoever will be able to help you.
I use OpenStreetMap for this use case so I can only answer for them, and they seem to do a great job at it. If I am looking for the general shopping area, or office areas, or anything like that, I can zoom and pan through a city and find it very quickly. That Google doesn't show labels anymore makes it completely useless (and I've run into that a few times).