There’s a wonderful waterfall at Montmorency Falls in Quebec. And Niagara, of course, from the Canadian side.
The one just outside of Quebec city is nice too.