Late September and most of October, I've seen good smallmouth, largemouth, and pike action at the bottom of the dam. Spinnerbait, chatterbait, crankbaits, and live night crawlers. The water level isn't all that high besides that one week in October.
The spillway is loaded with walleyes. Missed a couple of giants (over 24" at least). Had best success with crankbaits and swimbaits.
I heard there's catfish but I don't fish there at night. Locals say there's still great catfish action until the freeze.
Fish on friends.