I remember the ride up the Canadian side from Fort Erie to Niagara Falls to be pleasant, but it has been about 40 years since I last did it on a bike. I don't know if they've added a trail or not.
The ride via Grand Isle I also did but I don't remember that being nice. Once you were in Niagara Falls, NY, it was pretty ugly. Remember Love Canal?