I passed over both Assassin's Creed II and C&C 4 due to the DRM (both of which resulted in canceled preorders). After hearing the horror stories about the more recent DRM "innovations" the vast majority of my gamer friends have followed suit.
Personally I won't purchase Assassin's Creed II until a crack or patch is released that resolved the DRM problem. If that means waiting until the game is a $5 steam special I'm fine with that, I don't have to play a game the instant it comes out.
What is so annoying about this entire affair is that I am not a thief, pirate, rampant violator of intellectual property, etc. I just want to be able to use the software I purchase without my crappy Comcast connection compromising my single-player gaming experience. Is this too much to ask?