>just as much if you are doing it to get to or from your home that is on the road as if you are using it to get between two points that the road happens to connect

This is exactly the point and where the problem lies.

If I live on the road, and am one minute from home, and know that my neighbor's kid likes to ride his bike there - then I'm going to be very careful while driving down it.

If I'm still 30 minutes from home, and using the road to get from one 50mph main road to a different 50mph main road, I'm going to be in a hurry and not respect the residential speed limit as much.

It's human nature, and we can fight it by [1] having police speed traps in every neighborhood (expensive), [2] having speed bumps everywhere (annoying), or [3] adjusting the dials on Waze's optimization function.