I think Emacs eshell hits the sweet spot with this. Behaves like a normal shell for common tasks, with the ability to drop down to S-exprs if need be.