In my experience it depends how you use VSCode. For one project (and only a few well behaved extensions), even if it’s quite large, it can perform very well. Working in multiple projects the proscribed way (workspaces) comes with a variety of caveats. Multiple windows can increase CPU and RAM load pretty fast.