It's a matter of perspective I guess. Where I'm from, VSCode is considered lightweight. Cumbersome would describe NetBeans and Eclipse in my mind.
As you said, perhaps it's perspective, but even on my latest build (Ryzen 3600/RX5600XT/NVMe SSD) VSCode is agonizing compared to Notepad++ on Windows and Geany on Linux.
you're clearly not keeping 2793 files in your session.xml
That said, my usage is not sane and is just a reflection of my organization capabilities and the constant postponement of switching to a better editor (one with good multi-sessions management, for example). A large part of the files are RFCs by the way, that I need from time to time (or just don't care about closing).
I wouldn't be surprised if Geany were much better by the way, there's a lot I dislike in N++.