Navigate Directly to a Folder

Know the path you want to visit in OSX's Finder app but want to directly navigate there instead of using the GUI?

Cmd-Shift-G in Finder brings up a text entry field where you can navigate using commandline conveniences like ~/ and TAB completion.