This route is west-southwest of Plattsburgh, NY. Many different ways to get to it, for example, you could take Route 3 southwest from Plattsburgh for about 40 miles and then look for Port Kent - Hopkinton Turnpike on the right. Use the online map above.
Many ponds and a lake is what you pass by on this route. It seems the locals do some fishing, or what-have-you, here. It can be a scenic ride, if that's what you're interested in.
My apologies to the readers, and web admin, but it's hard to wax lyrical about the beauties of the area when that's not what I was there for. From what I did see it looked...nice?
I put ride enjoyment as 4 stars good, when it's really 4 stars 'good, for New York.' The pavement on the south is is mostly good, but with one mean bump you can see in the video. The north end, if you're on a motorcycle, you'll want to be a little more careful. It's quite lumpy, but if you're that far north and going north the show is pretty much over, anyway.
Mind the sand on the edges of the road. It's pretty well sorted on the actual road, but the edges do look sandy, and a bit dusty.
I would imagine there's tourism here. There's plenty of ponds and a lake. Google maps, that wonderful invention, shows 'Loon Lake Mountain Trail Head' 'Horse Head Point' and a couple of local lodges.
Motorcycle Road Additional info
According to Road Curvature this is, literally, the twistiest road in New York state. I don't know about all of that. RC has been a bit off before, but I know it's certainly out of place in this flat, boring, upstate area of this state near where my mother and sister live, in Malone. (Which is why I was up here.)
Be sure to check out the video for it, and if you want, hundreds of other twisty road videos you may wish to check out https://www.youtube.com/user/AkumuX