I think Dropbox/OneDrive have some form of lazy local syncing. As far as I know, though, there is no automated pruning of local copies of the least recently used files, but that sounds like a cool idea.

If you just want pure cloud storage that acts like a local disk, Azure File Storage containers are mountable (at least in Windows). I'm sure there is a FUSE driver for other cloud storage providers.