The smallmouth bass fishing is excellent, both north of the dam and just south of it just inside Great Falls Park. I've fished both from the shore and from a kayak. The biggest issue with fishing that area is that the river is frequently flooded.
I haven't fished there myself, but walk past folks fishing all the time. At a minimum, it's beautiful and I do see folks walking back with a catch.
Thanks! Your answer is awaiting moderation.