I think the Brooklyn comparison comes from the reputation for Brooklyn to be gritty. Troy has benefited from a massively popular farmers market which draws people (myself included) in from the burbs. (https://www.troymarket.org/the-market/) I usually pick up some homemade pasta and excellent homemade Hummus from Freddy's. However, just on the other side of the parking garage there is a bar with drunk/passed out/homeless folks outside on Sunday mornings. Broken window glass on sidewalk last time I went while loading up my strollers also reminds me of Brooklyn.
Here is a better crime map for Troy with data from the Police. It's not murders every day like Chicago, but plenty of crime going on with the occasional murder. Several years ago I had Police draw weapons across the hood of my car as I took a shortcut off Oakwood Ave to intercept someone robbing a convenience store.
http://communitycrimemap.com/?address=Troy,NY
Set the time period back 6 months...