I just got back from a 2 week (mostly) "staycation". We did go to Niagara Falls for one night, the Canadian side. The falls were great and we took our daughter on the Maid of the Mist, which was pretty exciting for a 6 year old. I always remembered the US side as being a tacky tourist trap, but the Canadians have really caught up. Junk stores and indoor amusements, all with blaring speakers out on the side walk. It really was stressful walking through all of that stuff, and I noticed a lot of people arguing and bitching at their kids. The next morning we walked down the stairs by the Skylon tower (another tourist trap) which was much more relaxing.
We also spent a day at Kelly's Island in Lake Erie, which was very relaxing. Long drive to the ferry in Marblehead though. We rented a golf cart and drove around to the beach and through the laid back island community. Nothing like Put-In-Bay, perhaps the most obnoxious place I have ever visited.