My best friend is an intelligence analyst out of the Hartford Fusion Center, so I guess I'll have to be the lone voice and make a case for him.
They simply act as a way point for intelligence coming into the state from outside agencies and decide what to disperse in-state and how to summarize it. My friend has written BOLOs and advisories that end up on the desks of state police dispatchers, military police, and local law enforcement. I used to get intelligence advisories from the fusion center that were directly applicable to my job as armed security on a military base, such as incidents at other bases.
As with any large government project, I'm sure there is waste. However, as someone who actually communicated with a fusion center professionally, I have nothing but good things to say about the Hartford outfit.