The simple fact of the matter is people get higher DPI mice because they want to increase the sensitivity of the mouse without losing accuracy. There is NO POINT in getting a copperhead if you're going to use it in 600DPI mode and then flick it across the desk at 100 meters a second, that's retarded.
I'd bet the vast majority of people get high DPI mice because they think bigger=better, thinking it will translate into more kills. In the end, they just end up lowering their ingame sensitivity to counter the DPI increase anyways. High sensitivity users are definitely in the minority now in online games, which is probably why razer/logitech have DPI switches on their mice to make them more friendly to the broader market.
People also got the newer/higher DPI mice because the sensors happened to be increasingly better all-round, not just the DPI. The 800dpi tracked faster and more consistently than the 400dpi mice, the 1600dpi was better still, (and the 1800dpi now appears the most consistent.) The present crop of laser mice happened to break that trend by giving an incremental improvement from 1600DPI to 2000DPI, while being vastly inferior in tracking speed, coupled with the fact that they're much more picky about their surface.
If you're only planning on using high DPI, high sensitivity under all circumstances, and aren't prone to doing very fast wrist flicks, etc.. then certainly I can see the copperhead being completely suitable. Personally my sensitivities happen to vary quite a bit across different platforms. Desktop use and deathmatching, I tend to be very high... for casual BF2 and other slow games, I'm more medium sensitivity. And by using an optical mouse I've never had to be concerned about moving my wrist or arm too fast regardless of what I'm playing.