I work mostly with ASM, C, C#, and a bit of VB. Even with 3 separate folders open, intelligence running, a couple larger files (of order 100mb) open, ~20 tabs with source and CSV, and a few plugins to help readability, VSC is taking up "only" 700MB.
Not exactly sleek compared to old-school editors, but not quite as bloated as your example.
It's well worth noting that plugins like the C/C++ extension run separate instances for each relevant tab on every workspace. When you have many tabs and many plugins, it starts to eat up a significant amount of space.
I don't have a 500k word text file laying around, but I tried an 80k line SQL script. FWIW, it's 8.5mb and the Atom wordcount plugin claims it's about 1.5 million "words".
Atom opened this file in 3-4 seconds and memory usage only increased about 30mb.
Navigation grinds to a halt with the wordcount plugin enabled. Once I disable its "always on" feature (normally it doesn't pay attention to .sql), navigation and editing seem snappy.
Just a data point. VS Code should be able to get much better...
Also, notepad++ is all over the place.
Which editor would you consider that is better with large files? Not really interested in switching, but really curious.