I avoid public negative judgments on places- I figure they're somebody's home town (although I may well harbour views!). I've only been in Trenton a few times but did have a meal in a nice patio backing on the river. Brownfield former industrial lands are difficult to deal with unless you can find another of replace it with housing/retail commercial/retail. Trenton used to be a fairly significant rail junction with the accompanying industries but all or most of that is gone.
So-called 'military towns', particularly those where it is the major 'industry', tend to have a more challenging history because of the more transient nature of the personnel and many of the amenities are self-contained on the base. Less so now - many of the amenities are now accessible to the public. Angus used to be one tough town before the base downsized (in terms of resident population) and it turned into a bedroom for Barrie and Alliston.
People have to remember that most small towns aren't theme parks like the Village at Blue or, some may argue, Picton. Although many do cater to whatever segment of the tourist population they can, year-round, they serve as a commercial/retail centre for their catchment area and struggle to attract and hold employment. In most cases, tourist income is a few months but expenses are year-round.