Corrected for inflation, the Federal government is spending more than the amount of the entire WWII debt every single year.
The kind of "beneficial" debt you're talking about is when you pay back that debt out of new wealth created by the investment.
When you're borrowing money to make payments on your debts, you're not in that category any more.