There are two issues at play: power consumption (in Watts) and the input voltages to the drive. As others have mentioned, the total power requirement for any consumer 3.5" desktop drive might be around 13W, which far exceeds what you can get out of a single USB port, which supplies 2.5W (5V * 0.5A).
The second issue is that 3.5" drives require both 12V and 5V DC power, whereas 2.5" drives only require 5V. USB 2.0 only supplies 5V.
You don't necessarily have to use an external AC adapter to supply the 12V for your 3.5" drive, but since USB only supplies 5V you need to get 12V from somewhere else, such as the following:
- an AC adapter that outputs 12V DC - this is what all the manufacturers do
- a desktop computer's power supply - you could wire your own 12V adapter that goes from the 12V DC IN jack on your SATA to USB connector, to the 12V and ground leads on one of the power supply's MOLEX or SATA power connectors (in a desktop computer). The obvious flaw with this approach is that it wouldn't be very convenient if you want to use the drive on a different computer, and would not work if you wanted to connect the drive to a laptop.
- a battery pack - portable and easy to wire up, but probably not a good idea because you could lose data if the battery died
- stepping up the voltage from several 5V USB headers - technically possible, but completely impractical on USB 2.0 or older ports (and still not very practical on USB 3.0). As others have noted, any random consumer 3.5" drive might require 13W to initially spin up the hard drive. A drive on my desk right now is labeled 12V, 0.5A (i.e., 6W). Assuming perfect power conversion efficiency, that means stepping up the voltage from at least 3 USB 2.0 headers (5V * 0.5A * 3 = 7.5W) or 2 USB 3.0 headers (5V * 0.9A * 2 = 9W). This particular drive also requires 5V, 0.85A--which could be taken partially from the leftover power supplied by the first few USB headers. Even if the labeled power consumption refers to the peak power requirements during spinup (rather than typical power requirements), we'll definitely need at least 5 USB 2.0 headers or 3 USB 3.0 headers to fully power the drive.
(NOTE: any modding or custom wiring is done at your own risk)
1While this does look like a shopping rec, the actual question is about the nature of USB vs SATA power requirements and the answers are good information without pushing any further into shopping rec. I believe this question should not be closed as shopping rec for these reasons. – music2myear – 2017-04-07T16:27:49.220