I wanted to get the demo for the latest Aliens Vs. Predator game. Turns out steam pulled it, so now I can't play it, even if I download it from elsewhere! So while the DRM thing is pretty annoying, [exclusive] digital distribution has its drawbacks as well.
I'll agree console designed can also be annoying (see the Force Unleashed games).