DRM only hurts sales for people who will pirate or swop games or lend to friends etc etc. Most consumers are unaware until it goes wrong and just deal with it. In an ideal world we would not need DRM but thats never going to happen so until it all goes digital download only (in about 10 years I reckon) DRM is here to stay. If PC gaming was healthy it would not be an issue as PS2 + X360 sold lots more volume so it never became much of an issue but the PC is the opposite where piracy has caused many publishers/developers to abandon or neglect it and if anything its getting worse on the PC.
As for STEAM thats not the solution a private company making huge profits from charging whatever they want for the convienience of a digital copy. The Orange Box & L4D were to me vastly overpriced and TOB especially forced the hardcore HL2 gamers to buy games they already owned and gift for nothing to others yet few complained for some strange reason about being overcharged for something they already owned

Its also easy to pirate their games so the DRM is a weak solution.