It's clear from the way the Internet is evolving (IPv6, more mobile devices, cloud computing, geolocation load balancing, etc.) that things like Nvidia's Grid and online games like this and Diablo 3 will rapidly become the norm. Even the way Gabe Newell talks about an online ecosystem and his Big Picture/SteamBox seem to orient in this direction, with an emphasis on streaming. You can quite clearly see that SimCity is partway to that end, as is Diablo 3, etc.
It would be interesting to see if "NEW IP" would be massively successful with an always on DRM.
As it stands today, these big publishers are taking
well known game titles, that were primarily SP, and holding them hostage with always on DRM.
So I wouldn't say, just yet, the online DRM is the future. I'd say it's significantly easier to get success from a well known title, that MILLIONS want to
ALREADY play, then it would be to get a brand new IP with always on DRM and get people on board to buy it.
SimCity and Diablo 3 would sell millions if they contained a pile of shit in the box, not really a good reference point for the acceptance for always on DRM.