I try to use eshell for whatever I can (some things still work better in a standard terminal), so I wrote Equake, a drop-down console (with tabs) in Emacs Lisp for eshell (though it can also open term or shell tabs as well):

https://gitlab.com/emacsomancer/equake (link include animated gifs of Equake in action)