I don’t have pictures of Colonie, but I could offer advice if I knew more specifics. None of the on campus housing is uninhabitable and RPI has services and methods of making things right where they may be wrong (maintenance, upgrades, etc.). Without knowing specifics about the “less than stellar” things you heard, it’s difficult for me to offer advice. What are you used to in terms of your standard of living? What did you hear that turned you off?
I will say that you will probably ride the shuttle to class unless you have a bicycle or like to walk. It’s about a 15 minute walk to class, I would estimate. You also have a convenient Rite Aid nearby.