Yes. Google Maps has pretty good coverage of popular trails and topography and can be used if you have signal.
> it doesn't help you navigate to 9134 Grocer Place
It absolutely can if you have some familiarity with the area and no signal. If from previous experience, you generally know where Grocer Place is then finding 9134 just takes patience. You don't even need to have necessarily been to that specific street before if you have a mental map of the area.
> a topo map would be less than useless
For finding a street address, true. But knowing how to read a topo map helps someone learn how to read and navigate natural landmarks which can be helpful in a natural disaster scenario or in a city if they are lost and no signal. I invite you to spend some time orienteering, I think you'll start to understand where I am coming from.