This isn't the default behavior for whatever reason, and it's something I've just silently dealt with for years. Because of this default functionality, instead of using Cmd-N I've always used the GUI buttons for creating new files while working on some project. I didn't think an alternative existed, but I've finally found that one does.
Keep on readin' on Make VS Code slot a new file in the current directory⟶