We see this currently in Germany, the German government is proud of their budget but at the same time the infrastructure is crumbling, trains are delayed, bridges are in need for repair or even replacement, broadband doesn't reach all places and I don't want to talk about climate change and the structural issue to which it will lead.
There is also one more thing about state debt, many people invest in state debt because it is a secure investment for the retirement and when a country no longer takes debt, this possibility is gone.
The ideology to have little or no state debt is hurting the economy and will do so in the future. And I'm not even talking about a recession or a depression which will come sooner or later.