Late spring through early autumn is the easy season: gardens are in bloom, wineries are open, and riverfront paths are pleasant. July and August bring the biggest crowds around the falls and the highest room prices.
Autumn is the best compromise, especially in the wine country when harvest season gives the villages a bit more life. Winter is cold and windy, but the frozen spray around the falls can be beautiful if you dress properly.