If the US Federal government were prevented from running a budget deficit, we'd likely see a lot more solvency issues and financial failures of many sub-organizations within government due to bad budgeting. It would also be a lot harder for our leaders to start wars or get away with sloppy cost estimates of their grandiose ideas.
My argument is not that government should be small, simply that its spending should reflect its income and the results of its spending should be easily correlated with their cost.
Since the Federal government takes the lion's share of income taxes, local governments are constrained in their ability to generate income. Yet for most people, local governments provide the vast majority of the useful government services they enjoy.
So while it may seem that the Federal government is comparatively stable and responsible, the reality is that it's simply far less accountable to anyone and is able to use that lack of accountability to launder its reputation. States (or local governments) do not have the same luxury.