Starforce did, for a time, sort-of succeed at what it was designed to do. I remember when you had to use a whole array of funky hacks and anti-Starforce apps in order to play a (pirated) game. It was a huge pain in the ass, and sometimes it was completely impossible to play an illegitimate copy of a new Starforce-protected game for weeks.
As for Battlefield 2: The One That Has Spyware, they should offer you to pay like 5 extra dollars or whatever to not install the adware. It's like yeah, it's adware, but it probably makes the game cheaper.
And as for GalCiv II, it was a relatively niche game and the exposure created by piracy of the game (this can only be speculative of course...) probably helped Stardock by expanding their core fanbase more than it hurt direct sales. For a much more hype-driven, mainstream game like
Half Life 2 you can't possibly argue that piracy was a financially benificial factor -- that's like arguing that P2P helped expand Britney Spears' (or her modern day equivalent's) core fanbase in such a way that increased total sales. And if some bothersome DRM scheme (like HL2's manditory 'net connection) can offer a glimmer of hope of delaying piracy for even the first few days of release, then they have to jump on it. Or maybe they should just make DRM schemes that expire after the first month
... bringing to mind a few games where later patches eventually removed some problematic DRM