The number of devices you are trying to attach is over the top. I'm personally not surprised you're running into a resource exhaust problem. I'm not certain there is much that could be done to get all of those working. Why so many drives? Why not network with existing drive(s) on another system on the network?
There shouldn't be a problem because I have been able to simultaneously use all 10 devices on my hub without any issues; been doing this since my SP1.
Everybody has their own use case and I can tell you that I have a NAS, but I also have 5 USB drives that I connect simultaneously to my hub to perform certain processes. Each drive serves a different purpose and I prefer to perform my processes in parallel rather than serially.
In addition to the 5, I have my Audio, Fingerprint Reader, iPhone, and Ethernet devices connected. That's 9 in use, on average, and that leaves one extra for my camera, TV remote control, ad-hoc USB stick work, etc. Bottom line is that everyone has his/her own use case and I have had no issues regularly using 10 devices simultaneously with my SP1 or SP2.