Back in the day (mid 90s), you could actually mount ftp.microsoft.com on your desktop, e.g.
c:\> net use m: \\ftp.microsoft.com\pub
That would have been a security nightmare tho' (SMB over the Internet, WTF) and they stopped it, so I'm guessing they still haven't quite figured it out.
Given how obvious mapping to a drive letter is as a feature, and how trivial one must assume it would be for Microsoft to implement, I can only assume they've deliberately crippled it for strategic reasons.
Assuming it's not just a delusional fantasy I hope GDrive gets this right, because this is a service I do want ...