Ubisoft backed away from always online drm after much criticism.
Diablo 3 and Sim City is the only one that currently use it to my knowledge and both games are getting crap for it. I don't see Blizzard changing its position on D3 but I could see EA cave and offer an offline mode.
The cloud gaming I can see happen if we are still gaming on closed systems with access to unlimited bandwidth.
Well, to be honest whether the processing takes place in the cloud or not is immaterial, it's effectively the same if you are forced to be online at all times *cough* Durango rumours *cough*.