This is essentially what Gvfs is for except basically nobody uses it, at least in the ways you describe, because forcing non-FS things into the shape of a FS usually doesn't work very well. So instead Gvfs gets used for relatively simple things that naturally map onto the FS concept well, like mounting archive files, browsing FTP, etc.