Upload file directly from a URL in upload (File/Open) dialog
The Go To Folder command you mention (command-shift-G) will only navigate your locally mounted volumes, it doesn't understand URLs.  I've never seen anything on the Mac that has the function you specify..