If you're seeing it in Device Manager, then you're seeing the USB --> SATA (or IDE) controller card. Seeing the disk in Disk Management is where you actually see the drive.
I concur that (if, indeed, it is operational) it sounds like the drive isn't getting enough power to spin up.