VSCode is an open-source and slimmed down version of a really good IDE, Visual Studio. It's a great choice for developing with MS tools like C# or F#.
Vim is an extension of Vi, which is mostly a set of primitives for manipulating text. As an implementation, I think Vim is not good. Vimscript shows its age. But this can be forgiven because the text manipulation primitives are so good. Vi, and to a lesser extend Vim, try to outsource everything that is not strictly text manipulation.
Emacs is a text-mode Lisp VM. Since (mostly) everything is text-oriented, it happens to have great editing facilities. But this should not distract you from the main fact. It's a platform. And it has high-quality applications (Org, Notmuch, Magit, Calc, Dired...) plus lots of libraries. Most importantly, applications can easily talk to each other in Lisp.
After more than a decade hopping around different environments, I decided computing is better done in 3 platforms. Emacs (for nearly everything), a web browser (just for hypertext) and a terminal (to deal with plumbing, Unix in my case). I've tied everything together with a tiling WM. I find it is a lot saner than using little CLI or GUI silos.
Somehow I've gone 30 years working without learning any emacs. Every time I try I get turned off by its philosophy pretty quickly. It's not for me, but maybe it's for you.
IDE's are awesome, but they come with a lot of weight that just isn't always needed. To this day I still us vi for all my quick checks, small edits etc even on projects within an IDE project (if I don't have the IDE loaded right then). I've been using vi since the 80's so it is just natural for me, but it is super powerful and requires very little resources to use. Even emacs while a pretty awesome editor is much heavier weight than simple vi and serves, IMO, a different purpose.
Do you spend time in console? On remote machines? Vi will be there. It is fast, you can start it right away, and once you get used to modal editing, it is really nice when editing configuration files.
With Emacs, your mileage may vary more, it has few killer apps (i.e. Org-mode, maybe magit, friend swears by notmuch for his email), but learning it takes time.
Currently, I use
* pycharm for python
* vs-code for programming in general
* vim for editing config files especially on server (but even when I need to edit .git/config, I usually open terminal in my vs-code and etid that with vim :P)
* experimenting with notes, blogging and and presentation-building eith emacs org-mode
So, for me it was worth it, you might find it too expensive of a time investment :-)
If you are hoping for some panacea of developer efficiency, you will probably be disappointed. At best, they are just another way to do most of the same things you can already do, with vscode. For some tasks, they will undoubtedly be more efficient or easier. For others, they will make your life more difficult.
If they interest you, sure give them a shot. Maybe check out some screencasts, and see if you like what they do/how they work:
Do you want an editor that is big on being customization and automation (a programmable text editor)? Then try using emacs. Loads of stuff you can change and automate. You can even use it as a simple web browser.
If the above don't interest you then VSCode is probably more than adequate for your needs.
Just the basic paradigm and few basic commands is all you need.