Thanks for that interesting "Steep Streets" link above!
I notice that at least one of those steep roads is restricted to 4X4 vehicles, only ... and that the reason seems to be so that low-range is available (and required) due to the steepness of the grade.
FWIW, our GMC 4X4 Z71 offroad pickup has a non-stock front axle engagement system setup I installed so that the truck can be in low-range, but still only be in rear wheel drive if desired for special situations. We use this 4X4 drive setting when pulling up very steep roads that are also paved. This provides extreme pulling power for towing trailers, etc. when on very steep paved roads ... which could otherwise ruin gears due to 4X4 low range drive system wrap-up on hard surfaces.