Central, Northern, & southern NY always gets my vote that time of year. I also second the Raquette with the release and rain influence from lake colden down. But there is so much out there. Aquiduct alley on the Chazy river. The chateaugay, mettawee, John's brook, independence, the Branch etc. rain is your friend that time of year and typically you get some rain influence water sheds frequently.
don't forget canada is just a hop skip and jump away. The Rogue (7 sisters) Lachine chamblie but it starts getting cold that time of year up there.
Then like everyone says you have WV, Penn, Conn, Mass Vermont Maine NH all in less than a days drive except maine. thats a full day. good luck have fun and check out New York Explosed the Whitewater State Vol 1 and AW obviously....
" ...this is the hardest sport I've ever tried!!",E. Brown, 2003