> Isn't that only true if the government is spending that money in a way that creates wealth down the line?

Yes exactly. Which is why the amount of the deficit isn't particularly relevant, it's how it's spent. For example, giving everybody COVID relief cheques makes inflation worse, but spending on green infrastructure lowers inflation in the long term.