I was a Troy resident for the last 3 years and I lived right in Historic Downtown. I personally love Troy and since I moved a few months back miss it, I live just up the road but it's not then same. There is a great since of community in the DT area. The whole New Brooklyn thing was a coined term by 3 or 4 guys that have moved to the area from Brooklyn in the last few years and have opened businesses and have inspired others to move up to give Troy a chance as the area is in a pretty big "growth" stage and Brooklyn has got ridiculously expensive.
Troy numbers: nice 2 BR in a brownstone apartment 5 years ago would rent for $700 now they can go for upwards of $1500. These guys hit the market right and were buying 5 to 7 unit buildings for around $200k and now they are killing it.
Now you can't find anything, it's all been bought up. But that has put a highlight to the surrounding neighborhoods and has caused some gentrification and made those neighborhoods much more approachable for an investor. You can pickup 2 families for around $80k and still get $900+/month for a 3BR.