I hear you on the Hartford dump being 'insulting' but I'm not sure that them going to Hartford was thought of in the way you might be thinking of it. The trip to Hartford might have been necessitated by the fact that their local transfer station was closed and Hartford offered daily pickup. Just a theory on my part but I don't think FD/MT had many trash disposal options at the time of day that they made their trip down Albany.
Most towns (other than large ones) in CT don't have organized town wide trash removal. People arrange for their own trash removal and so garbage trucks are usually around most mornings on their route for customer pick ups. NC people either take their trash to Transfer Station of have private company come and do removal. Farmington looks like it has some organized system of trash removal (link below).
So, if you were in Farmington and needed to get rid of trash you would have to either put it into your own trash and wait for pickup (not a good option for FD IMO!) or perhaps take it to the town transfer station (most towns have place where garbage and recycling can be taken - NC has a very comprehensive garbage/recycling setup
http://www.newcanaan.info/content/9490/293/319/873/default.aspxand here is info for Farmington
Trash and Recycling | Town of Farmington, CT).
It also appears that Farmington has some kind of organized pickup system (anyone local to explain?)
http://www.farmington-ct.org/home/showdocument?id=15491
Hope this helps explain why Hartford might have been only option based on the time of day.