I agree that a lot of this either exists today or will int he very near future. Seems to me much of the same ideas are being floated by the VMWare folks and their Virtual Data Center OS ideas. The ideas of provisioning more resources automagically when they are needed (vMotion?). Having no idea what physical machine is actually running your database, VMWare Clustering etc. etc... Granted this is all for your internal intranet type of thinking, not so much for including services provided from the web.

EDIT: yes I know MS is talking about the same types of things, I just am more familiar with the VMWare product offerings... please don't shoot me for only talking about VMWare. I don't work for them I just use their products.