Moreau Lake is the easiest start: water, colour, and a short walk from the car, which matters more than people think if anyone is in shoes they care about. The Lake George overlooks on the eastern side are worth the climb for the long view down the water.
If you want ridges stacking into blue distance rather than reflection, head toward the Catskills instead. I avoid the roadside pull-offs along the Northway in the first week of October. So does everyone else, which is exactly the problem.