You may find AAA titles may rely on online functions to deter warez users, not all Publishers will use that though.
This is a day and age of digitial distribution so by default most protections schemes are online based now, even on retail media copies.
It's not an ideal thing as it won't reach 100% of customers, as some areas in the US there is still 56k users (and the same can be said in other countries), so they can't be always online and cope with high bandwith usage.
But the majority is broadband users either cable or ADSL, so it works in the background for them.
Titles like Starcraft 2, Diablo 3, Assassin's Creed 2+, Far Cry 3, Sim City etc are online but some of them are able to be played offline.
An example of 2 of the above
Starcraft 2 obviously disables achievements
Assassin's Creed 2 Brotherhood etc had shops functions removed (as in unable to invest)
Far Cry 3 allowed playing offline, you just missed out on multiplayer functions and obviously no achievements as such.
Compared to the amount released last year, Always Online games was a small percentage of them, again proof that people are blowing the situation way out of proportions. They will not be happy their AAA title they wanted become always online so make up this story that it is happening to all/most titles.. that is obviously not true.
I know Dragon Age 3 which is being worked on, will not be always online, but will have online features. Same for the proposed 4th ME (its sketchy but so far again same as above).
EDIT: As for is it a deterring thing for cheats... no the always online function isn't to deter people who cheat, as said it is to deter the warez users as much as possible.
And as said because of the Steam platform, achievements are now a big thing but again not all games will punish you for cheating in SP, Fallout 3 and NV for example was fine with it as was Skyrim (they allow mods that are cheats and you still can earn achievements).
Most people complaining are people who were warned not to use cheats while online in games like Starcraft 2 as a good example, Blizzard warned people and they continued to use trainers and got banned. They will blame Blizzard of course en masse as if Blizzard took their right to cheat away, they didn't thats why it had an offline function.
And also with Black Ops 2 recently people used the trainer on the Zombie mode, and got banned because it had an online function, again people blamed the Devs and Publisher and in some cases even blamed the staff at CH.
People like that only have one person to blame themselves, but thats to hard for them to acknowledge and it's easier to blame others instead.
[Edited by DABhand, 3/9/2013 12:22:29 AM]
I mainly hate the whole online social functions in single player because single player isn't meant to be online. When I play a single player game I don't want to be bothered about what my friends are doing in the single player. When I play a single player game I want to be left alone when playing it and not have to be online or have social functions implemented into the single player.
If I wanted to play a story based game with people I would play The Old Republic or Guild Wars 2.