Google maps, around me, is incredible for local route planning before and during rides. The vast network of MUPs and bike lanes is up to date.
But in terms of streets, if all there is to choose from is highway or gravel, i cant say what it would choose. I havent tried to use google maps in that way.

Click the line that is the route and drag it to where you want to go. Thatll reroute the line. You need to manually change the suggested route sometimes.