So Troy does have kind of a bad reputation...there was actually a string of shootings a few weeks ago. The thing to remember though is to be smart about your surroundings. If you're wandering around alone at 2 a.m., you're probably going to run into trouble. During the day, though, Troy is great! There's a sort of revival going on, and it's getting to be a really fun place to explore. Downtown has a fantastic farmer's market and often flea markets. Lots of artists are setting up shop, so it's always fun to peruse their stores.
I've always dealt with really friendly people, especially shopkeepers and people in restaurants. As far as what to do and eat, Troy is about 15 minutes from Albany. There's a huge variety of foods, especially if you're willing to explore. There are 2 malls with movie theaters about 15 minutes away. Albany has things like rock climbing gyms and good bars.
As far as facilities:
Library- Very extensive collection, and if there is anything they don't have they can order if from a consortium of college for free and have it delivered in about 2 days. There are also many study rooms to reserve.
Classrooms- They vary considerably by building. My only issue is that since some buildings are old, they struggle to regulate the temperature.
Career Center- My opinion on this is a bit biased. I went to them once to help me with finding internships and tweaking my resume. They couldn't really help me because there's not a lot they can do for a biology major :/ Which I guess means they'd be able to help you as an engineer!
TL;DR Troy is ok as long as you aren't running around at night; decent variety of food; great farmers market.