If the drive case is USB 2.0 then any USB 3.0 port it is plugged into will revert to USB 2.0. The USB 3.0 protocol may support 900 mA but USB 2.0 does not, so if the drive adapter lacks support for more power then the computer will tell the drive that it should not draw more power.
There's extensions to USB 2.0 and USB 3.0 to allow for more power than either protocol supports on its own. One is USB-BC and the other is USB-PD, and if the host supports one or both then it is possible to get 1.5 amps from the USB port. Also, not all USB ports will support the maximum power allowed by USB 2.0 or USB 3.0. It is unlikely but still possible that the USB port supports only 750 mA, or whatever, and this is insufficient for the larger drive and the conversion electronics. Given that the drive case uses a separate power supply the power supplied from the USB port is likely moot, the drive case should be getting all power from the power brick. If for some reason the drive case is taking 5 volts from USB and 12 volts from the power brick then it is still possible that you are seeing a lack of sufficient power because the adapter electronics is taking power in addition to the power the drive requires.
If we assume the drive case is taking all power from the power brick then you can still see a shortage of power because the adapter electronics takes power, and there will be conversion losses in stepping down the 12 volts to 5 volts. Given that the lower power drive works and the higher power drive does not then it appears it is simply a matter of the one drive requiring more power than the drive case can supply.
In short the part you are missing is how much power the conversion electronics consume. The power brick may be large enough to supply twice what the larger drive consumes but if the conversion electronics in the drive case takes the majority of the power supplied then there is simply not enough left for the drive to spin up.
Check the specifications on the drive case on how much power it can supply to the +5V and +12V pins for the drive, chances are that your drive is more than it can handle. If the drive case specifications don't tell you how much current it can supply to the drive then just your experimentation should indicate that the drive case isn't built to handle the drive.