Empire: Total War has a mandatory connection to a unique unchangeable steam account. It causes me an unbelievable amount of hassle, my brother never uses Steam, but it's his account and an old email address so if we stop playing it for a while we've got to spend half a day trying to dig up antique user information just to play a game we have the disk for.
And of course we can't resell it, so yeah. I don#t get much use out of Steam in general, being able to download and redownload things is the only real benefit I get and so all Steam does for me is add a couple of seconds onto the loading time of the games I've got with it, so I'm not a huge fan, but at least it's more understandable with a downloadable game. Less so for a third-party disc game.
Funnily enough Origin has caused me less problems. It doesn't seem to load up in the way that Steam does and I haven't (yet) had an EA game Origin locked, never mind a non EA game