That being said, I've had trouble getting the TurboTwist 2 spinner to work in Windows. I had it working initially after installing it, having to unplug most of my other retro controller > usb adapters for it to stay put. However, after testing it out with Super Breakout and Tempest, I took a break and tried it out again later.
Now it is back to its old behavior of appearing under Windows 7's "Devices/Printer" menu as "TurboTwist 2 Spinner", then changing to "USB input device", before disappearing completely and reappearing a few seconds later.
This is strange. It should simply "work", as all parts like this are tested before they get shipped. This could be any number of issues; A bad cable, as already mentioned, an overloaded USB port, something shorting the interface PCB as a result of the way it is installed, a flaky computer or power supply, etc... While unlikely, it could also be an intermittent problem with the PCB. If proper care was not used when handling it, static damage is a possibility.
If you have or can borrow another cable, try that first. Then try a different computer to see if it's just happening on that particular system.
Make sure you don't have some non-standard mouse driver on the system which might be confusing things.
Disconnect the hub and other devices to see if there is a defective device on the same physical port which is mucking things up.
Try every USB port on the system, in case there is a defective port. Note that multiple connectors are usually tied to physical single ports, so try all of them.
And most importantly, note what, if any, differences you see in what occurs based on each thing you try. If all of the above result in identical behavior, it's time to suspect a damaged PCB.