If you have access to a car Mass MOCA is in North Adams, MA and is worth the hour drive. First, you drive through the Berkshires, which are always lovely. But the museum itself is a gem. A few years ago I saw the entire The Course of Empire series by Thomas Cole and they had a JMW Turner exhibit which kicked ass.
I lived in Albany for two years and was bored for most of it. It is a college town surrounded by ghetto. So if barely legal boys who hold their liquor as well as their conversations are your thing. Enjoy. Waterworks is the only place you need to go to. If Club Phoenix is still open, that is my preferred watering hole. It is a gay club masquerading as a fetish bar. Plenty of gentlemen wearing leather, but they leave you alone if you growl loud enough. They have the biggest dance floor and the best music out of all the venues.
Lark St. is a one stop place for a night out on the town. Some restaurants, some cute little shops, and Oh Bar is a cross between a piano bar (sans piano) and a dive. I have had plenty of pleasant chit chat there with a crowd that runs older than 30.
It can be a nice little town for a few days. But I am glad I don't live there any more.