I think we can agree on one thing: Steam mandatory will piss off a lot of customers because it'll be seen as annoying, arbitrary and I'm going to be fair, some people consider it bloatware. Steam version, I have no problem with. Just don't FORCE me to install it.
Well, it's that way with ALL DRMs. They FORCE you to install SOMETHING, whether it tells you or not.
At least Steamworks tells you it's installing something, and not installing something that could be considered malicious without telling you.
All in all, I think Steamworks is the best choice if we have to use a DRM (besides a simple disk check anyway). GFWL is severely flawed, SecuROM and others like it are basically malware (some of which are impossible to remove without wiping your drive), and the rest require CONSTANT internet connection.
Well, I'm happy about one thing if it really is using Steamworks. At least I won't have to stand in line with hundreds of loud, obnoxious, and sweaty people waiting to get a copy. I'll just save myself the trouble and pre download it off of Steam and wait until midnight (Valve-time) to unlock it.