Well, the patching system is done in such a way to negate the need copy protection from what I understand. Yes, it isn't effective for everyone, but sadly developers can not always do things for 100% of the consumers. After all, if copy protection were in place, using say Starforce, then there will be people out there who won't buy it. Other than that, the actual support, when there is a problem I found to be great.
I've also had a small problem with my video card, but the simplest way to resolve that is to restart, thankfully the game doesn't take long to load.
This game is worth getting I reckon if you need a break from Civ. In some ways, I'd say its under-rated, but it does also require a fair bit of micromanagement at times.