So of course it cries out to be photographed! ...from a safe position outside the barrier, which you will see in my second photo. The black and white fantasy shot has only been manipulated in one way: I duplicated the left side of the picture, flipped it, and placed it on the right to get a symmetrical image.
Here is what you can see without poking your head (or camera lens) through the fence.
This is a view from over the river, on a functional, properly maintained pedestrian bridge. The Raleigh Greenway system offers many pleasant areas to hike or bike. Crabtree Creek itself is scenic, although it is usually opaque with mud and sediment from the quarry operations upstream.
Not a bad little slice of a fantasy view, within shouting distance of houses, apartments, and business parking lots.