I agree, not all debt is bad. Even in our personal lives we know giving money to our deadbeat drunken relatives is not productive (ie.welfare), buying pharmaceutical drugs is not productive (ie. heathcare) but a necessary evil; travel, electronics, cars, boats, etc are all not productive. Stocks, housing, savings can be productive (ie. infrastructure, investment).
I like seeing the government help push initiatives the private sector has a tough time justifying either due to insufficient foresight or unjustified return but known to at some point raise the standard of living. Prime example is R&D where most companies are only looking 5 years out but need grants and university involvement to encourage the 7-10 year investment. Also things like high-speed railway networks are very costly to initiate especially for a single private group, but could make travel much more efficient. I actually see huge value in the role of military as a research and manufacturing vehicle to drive technology and innovation. But not in the way it is now with invading other nations and nation building.
Unfortunately government has become a vehicle for mass charity where everyone is voting themselves money and looking out for their own self interest. Companies are donating to the politician who will give them the biggest subsidy, hand out, tax cut, etc. People are the same, looking to not pay for healthcare, pay less tax, retire younger without saving. The spending seems to continue the trend of a consumption based economy not a productivity based economy.