I was really disappointed that I didn’t get to go a second time, during a maintenance a few years ago that had the entire Canadian side blocked dry. Would have been so cool to see how the rock has been shaped.
Niagara Falls isn’t too far out of your area, 9 hours for the American side, maybe 10 for Canadian. Walking on the pier under the Canadian side is incredible, if you are willing to pay for the ferry ride.