My intuition is that it's obviously right that borrowing money could be a neutral or positive thing - but that depends on the borrowed money being spent in ways that will have a positive return. If you borrow money, when borrowing is cheap, to buy a car so you can go to work, smart! If you borrow money to spend it on booze and concert tickets - not smart!
I think the issue is that one side is saying "Borrowing is terrible!" And the other side is saying "No, borrowing cheap money is somewhere between fine and great!" And the real answer is "Borrowing can be smart if you use it well, but we are using it poorly."
If the US was borrowing money to build and renovate roads, bridges, ports, update the electrical grid, build new nuclear power plants, engage in basic science research and similar projects likely to yield good return on investment - that was be amazing financial planning. My limited understanding of what the government actually spends its money on - wasteful healthcare, social security, the military, and intelligence agencies - is that the money is actually just being squandered.