I live in the area (on the Canadian side) and my personal favorite is Riverside
Riverside as it is on the Niagara River and the Niagara Parkway about a 15 minute drive from the falls. If you do not want to drive then the KOA on Lundy's Lane is my next pick.
Parking is expensive around the falls in July/August and I recommend using the
WEGO bus system to get to the major tourist attractions. There is a BIG parking lot South of the falls just off of the Niagara Parkway at Upper Rapids Blvd. and a free shuttle from there to the falls themselves.
If you want to tour the major attractions along the river look at the Niagara Parks Adventure Pass which (last summer) included The Fury, Journey Behind the Falls, White Water Walk and the Maid of the Mist. The list varies a bit from summer to summer so you may want to take a look at their web site
Niagara Parks later in the year. Right now it only is showing the winter items.
Hope you enjoy your visit.
BillB
2000 Dodge Ram Quad Cab 1 Ton Diesel, 4.10 axle w/limited slip, auto trans.
2000 Real Lite Truck Camper