StoneyBrook was cool. You actually walk in the stream and can go swimming at the waterfalls and whatnot.
Couple places in the Niagara gorge. I’ve only gone on the Canadian side though.
Watkins glen is a paved path along the waterfalls. Great place for pics, awesome views, but I don’t like not being able to get close to the water without getting bitched at by a parky.
Fingerlakes region offers ALOT. Just have to find it all.