Did you mean Route 9? In the Albany region, there is the main Route 9 and numerous route 9s followed by a letter (9G, 9J, 9W etc), so be careful. Circa 1990, I did several Multiple Sclerosis 150 rides from East Greenbush (just east of Albany on the east side of the river) to Poughkeepsie (75 miles each way). The ride to Poughkeepsie followed 9J, 9G and 9. 9J and 9G hug the river and there are many nice views. 9 near Poughkeepsie had heavy traffic any was not very enjoyable. The return ride from Poughkeepsie followed many nice rural county roads for about 40 miles and then 9H and 9. Route 9 on the East Greenbush end wasn't all that enjoyable either. My recollection is the first half of both days was the best. Below is the cue sheet from Poughkeepsie.
My recommendation would be to follow the cue sheet below and then cut over to 9J or 9G at some point. There are also several worthwhile historical sites that side of the river, including Olana, Clermont and Martin Van Buren's estate. The county roads in New York are generally very nice. They have good surfaces, are well maintained and don't have much traffic. You will have to pass through some congestion in Albany. The Mohawk-Hudson Bikeway runs from Albany along the river toward Cohoes, but doesn't go all the way to Cohoes. You'll have the cross the Mohawk River at Cohoes or cut over to Route 9 (Loudon Rd) and cross it there. You'll then be in Saratoga County, which has an excellent network of county and town roads. The I87 corridor is busy, but if you stay a mile east or west of it you'll be fine. East Line Rd runs north/south on the west side and is a good route. I don't know of any campgrounds along this route.
2.8 R West Dorsey Rd.
6.2 L 39
8.1 R 41
13.4 L 115
13.9 L 18
22.0 R 19
22.5 L 15
25.3 right fork at junction with 52
26.8 R 199 at stop sign
27.0 L 51
30.0 L sharp left turn
32.3 L 50
32.7 you are now on route 2 Columbia County
36.0 R 19
42.6 R 19 at stop sign
43.5 9 continue straight at stop sign
45.6 9H continue straight