Welcome aboard the RoadTrip America Forums!
That general area has been covered in some considerable detail before, so let me first suggest that your read these discussions of New England destinations and these of sites between Niagara and New York and Boston. You should also look at what's available in the Thousand Island region at the head of the St. Lawrence River. The other thing you'll need to keep in mind is that the time you plan to be traveling is near the peak of the fall foliage season in northern New England and southern Québec and Ontario. Roads will be quite busy and lodging reservations are highly recommended.
AZBuck