Vim can do the same
Without 1 trillion unmaintained buggy plugins installed? I don't think so.
I regularly use Vim when there's no X11 or Wayland environment i.e. on servers, but that's the only thing what Vim is good or maybe even best for. Trying to hack it into full-scale IDE is actually breaking Unix philosophy do one thing and do it well.
without consuming all your RAM
Emacs hardly can consume all my 32GiB of RAM. I usually have around 5 workplaces opened with two or more windows in each including fat FF, Thunderbird, Element, etc. and I didn't notice any downgrade in performance since I started using Emacs instead of the other GUI code editor.