Skylon Tower is the most direct way to get above the spray on the Canadian side of Niagara Falls. Its observation deck looks down on Horseshoe Falls, across to the American Falls, and out over the dense strip of hotels and attractions that has grown around the gorge.
It is not subtle, and that is part of the Niagara experience. Go for the view rather than the shopping arcade below, and time the visit for late afternoon or evening if you want the falls lighting and the city lights in the same sweep.