There are roads just like this and more all over rural America. This stretch of curvy road is apparently on State Highway 42 in Wisconsin someplace. It is quite a wiggly stretch, but I suspect the perspective has been intentionally foreshortened here to make it look even more extreme than it is.
Similar camera field of view tomfoolery results in infamous images like this one...

...Where traffic appears to be driving up a sheer wall.
Viewed from the side the bridge in question is still pretty steep, but looks considerably more tame.