I fish that spot alot during the summer and have lots of luck, im also one of the idiots that you may see jumping off the bridge, so yeah its pretty deep under the bridge
Also above the glenmore bridge there are some nice deep holes along Beaverdam Park and the train bridge. If your spin casting i would suggest a red and white spoon(red stripe), black and white spoon(black stripe), five of diamonds is good too, tend to catch more whities on that though, or i also have good luck on a panther martin spinner with a silver blade, yellow body with red or black dots.