The biggest issue that content producers/middlemen need to acknowledge and learn from is:

Your product will always be pirated. So the real issue is, how many customers do you want to **** off in your quest to protect your product. And remember, some of those customers might just go pirate it (out of spite) or because it's easier than dealing with the DRM mess.

From what I've seen on the PC games, I find Steam's one of the best. It balances DRM without causing too many troubles to the user.

Edit: Some of the things that happened during the Humble Bundle donation/sale were interesting too. Even if the price was 1 cent or 0, people still "pirated" the software. Indicating that it's not price or even DRM that's necessarily an issue. It could even be distribution and methods of advertisement (alot of people were posting links to the download and people who had no clue about what was happening were downloading it).

All of this just shows what most companies advocating stringent DRM don't understand. That piracy is a multi-faceted problem and one hammer solution (e.g. DRM) doesn't work if you don't tackle the other angles.