That's all very well, but how do you explain Castle Ridge Rd? (last map) There are also some loops that have the same weight as dead ends.
Alternative explanation: the municipality surveyors assign prominence-values to roads, based on width etc, which happen to (often) coincide with dead ends being lighter. Google uses these values; competitors don't.
I agree it is a nice effect, both useful and beautiful.