Speaking only for myself, and making no claims what so ever as to how many people are in my same situation with my same reaction …
There are around 150-ish games (some as old as the original Doom) installed on my main gaming machine and every single one was purchased as a legitimate new sale through regular channels. I have fast, reliable internet access wherever I am that I might want to game, across all the machines (2 desktops and 1 laptop) that I’d potentially use to game.
That said, I steadfastly refuse to purchase any game that requires me to have an internet connection to play single player only (this obviously doesn't include MMOs and other on-line multiplayer titles). I’ve passed on several games which looked quite interesting solely because of the ‘must be connected to play’ requirement.
I also tend to spread my gaming time across 2-5 different games at a time. So one day I’ll log into WoW for a couple of hours, the next I’ll re-play BioShock, F.E.A.R., or Thief: Deadly Shadows for a bit. As a result what I’ll do in many cases is go to a couple of trusted sources for cracked .EXE files for the single player games, so I don’t have to sort through my game discs to make sure I’ve got the correct one in the drive each time I get a whim to play something. And this is for games I own, have never let a friend ‘borrow’, and for which I still possess the full retail package. If that's not an option and I have to have the disc each time I want to play I'll still purchase, but it annoys me and I wish it weren't the case. 'Must be connected' is different, and that's where I draw the line.
I don’t like having to prove I’m not a pirate each and every time I want to hop into a game and relax. I don’t want to have to worry that some day the online service I have to connect to to play a single player only game might start pushing out ads (even non obtrusive ones), delivering content I didn’t ask for, or doing anything else that takes up any of my bandwidth or computing power that isn’t needed for the game itself.
Does the ‘must be connected to play’ requirement stave off piracy to the point where it’s a net benefit to the game designers? Don’t know. Is it the best overall way for them to deal with sluggish sales? Don’t know. Am I just a single, irrational voice in the wilderness over-reacting to evolving software models? Don’t know, and what’s more, don’t care.
I do know that there is at least one person (me) who refuses to purchase something for my entertainment which will dictate the way I will enjoy it and also gives me a set of requirements to prove I’m not a thief each time I feel like enjoying it.
My $0.02.