Online "activiation" is one thing, having to be connected to the internet everytime you want to play the game is just annoying.
Take your XBox or PS3 console and require you to have internet access to play the game ... is that good or bad????
Using steam for copy protection is pretty stupid anyway, the people that play cracked version are just going to crack this one anyway, so what real difference does it make? I have also read (not sure if true) that there is already a cracked XBOX 360 version of the game floating around. Sad that people can't just pay for the stuff they want to play .... sadder still that producers have to punish those of that do actually pay for the games.
I dont even have steam but i do know they have an offline mode, which requires you log on every couple weeks or so to show youre not tampering with the game.
Consoles do have the benfit of being offline only if you choose but there are still consequences:
-Your copy of the game is on a disc, if disc gets damaged you need a new one. You can downlaod the game from steam, so it works as a backup system.
-Console users dont have the creation kit, so they are stuck with only official patches in order to fix w/e bugs exist. PC users get the added benefit of mods for worarounds and/or customization of their game.