It's more of a gentle slope farther from the dam. As you get closer to the dam, it gets steeper and more like a wall, but you can stay at whatever depth you are comfortable with. If they have a generator or two going, the sensation of the pressure waves in the water as you near the dam is pretty cool. The entry is pretty easy, have to carry gear down a little slope, but it's pretty "beachy" if you don't mean sandy beach. Lots of variety in diving in a small area, for this area, just don't expect a lot of vis, and remember that once you get past about 25 feet it gets cold fast.
And you aren't goofy at all for being intimidated by depth, especially in murky water. I've only been diving a year, and each dive adds a lot to confidence, knowledge, etc. And start saving money for an ocean dive.... 100' visibility is a whole new world !)