I'm frustrated by these companies' decisions to mess up good games with bad technology. I don't think most of the people involved are particularly stupid, but they are dealing with a complex issue with an awful lot of hidden information, inertia, ill will, and DRM salesmen paid to pick and choose facts to further their own bottom line. I don't claim to know if DRM is making or costing money to any specific game release. I can, however, work towards making it cost them.
Some DRM is good for the gamer. When a network-only game is coded defensively to make cheating less likely, that's effectively locking it up, but does the grand majority of gamers a favor. However, DRM on a single player game carries no positive expectation whatsoever for the gamer. There is a reason the majority of productive software does not have any DRM apart from entering a license number at install time (if that).
Furthermore, something like network activation turns what used to be a normal game sale into a rental of indefinite duration, changing the product's very nature.
That, by itself, is fine. I'd generally want to buy games for keeps, but if they only want to offer it as a rental, I'll rent. What's not fine, however, is still selling it on the same shelf with the other games and deceiving/misleading people about the nature of the product. That I regard as downright slimy. If you think this is accidental, look at the way 2K publicized the removal of install limits on Bioshock, and tell me that was not deliberate. They made an incredibly vague announcement, and after game sites had had time to report it as "2K removes DRM from Bioshock", they added to the initial announcement saying only the install limit is out (translation: Bioshock is still a rental). Retractions, if done at all, are done quietly and read by few.
I also am not going to pay full price for a rental. When Bioshock, ME and Spore get to $10, maybe $15, we'll talk. Same thing with stuff on Steam. I'm not setting fixed limits; I'll buy the games when they are priced reasonably in light of an assumption that the game will at some point stop working. If they want me to pay more, they are free to remove the activation and sell the game to me.