you're where in Colorado? Ft Collins? Greeley?
The area in New York you're asking about is quite pretty but definitely has a different feel than where you live now. There are mountains to the north (Lake Placid ski area and others if you're a skier). In the warmer months, it's going to be greener with more trees (gorgeous in the Fall) and in the winter it'll be colder, grayer and there'll with more snow than you're used to. I grew up in suburban Denver and went to college in upstate NY. The first thing that struck me when I got off the plane was the humidity followed by how green everything was in early september as compared to the high plains around Denver.
schenectady-albany-troy(the general area you're asking about) is an older settled area and despite Albany being NY's capital, the area has a small city atmosphere. Some people think it's kinda quiet and dull compared to other cities in NY. When I lived in upstate NY (a while ago now!) it wasn't an expensive place to live.
I had a motorcycle in those days and absolutely loved riding in the hills after work in the summer.