I agree with Talisorn. I don't see what the big deal is about the Ubisoft DRM. Millions of people around the world don't have an issue with this type of DRM when it's attached to World of Warcraft, Age of Conan or any other MMOG. Yes, AC2 is a single player game, but a large portion of MMOG players play them alone.
All of the same issues exist in WoW that exist with AC 2: If you lose your connection, you can't play, you can't play on the plane or other places that don't have a connection, you may not be able to play it in 5 years if the server gets shut down, etc. But millions buy and play them. As for the server issues, UO and WoW had major connectivity issues when they launched too. And the Ubisoft server issues are being caused by an external malicious DDoS attack, not by their own poor planning.
Do I wish that it could be standalone and I could keep it forever in my collection? Sure. I was playing Sid Meier's Alpha Centauri over the weekend on my laptop while my wife worked on my desktop. I like having standalone, SP games in my collection.
But I can't blame Ubisoft for trying something out of the box to get a handle on piracy. And most of us already play games on Steam with hardly a complaint. While it has an offline mode, I have yet to set it up and use it after 2 years and dozens of games because it has been so stable.
Will it cause trouble for real consumers while the pirates still get away with it? That remains to be seen. If it does, I hope Ubisoft does the right thing and patches the game so it can be played offline, but so far there are no stable cracked versions. If it has an effect reducing piracy rates (and it could take years to discern this) you'll quickly see everyone adopting this methodology for better or worse.
Honestly, if it's a choice between this and not having good AAA games on the PC to play, I'll take this kind of DRM.
If Russia stops fighting, the war ends. If Ukraine stops fighting, Ukraine ends. Slava Ukraini!