I use vi (or, if available, pico) if I must
, but fortunately BBEdit covers practically all cases I currently need. Where necessary I use BBEdit's built-in SFTP client to access files on remote servers transparently.
It's nice to have console-based editors as an ultimate backup if everything else should fail, but that is inceasingly rarely the case. And I'm happy about it as the console editors are incredibly cumbersome and slow compared with a proper graphical one.
Key bindings, regular expressions, programmable text processing, integrated CVS
support and many other features are available in BBEdit as well (combined with cross-application scripting through AppleScript).
I'm not missing anything - and the Editor is my primary working tool.