From NewYorkUpstate.com (includes many nice photos):
It would be hard to be disappointed at the views from Prospect Point at Niagara Falls State Park, and that’s probably why more than 8 million people visit every year. The stunning view by day and by night can leave a visitor breathless and struggling for superlatives. You can walk out high over the Niagara River Gorge at the Prospect Point Observation Tower, or you can walk down to feel the spray coming off the Falls.