I've been buying from these guys for 15 years or more https://www.macsales.com
Right now I have a Mercury Elite Pro Mini via firewire on my desk and one of their SSDs in my Macbook.
they don't sell junk, so anything you get will be fine. If you want portability get an on-the-go, if you just need something for the desktop get a larger enclosure.
The spin up spin down is generally set with your system preferences. A drive with a faster RPM is, well, faster, but might need more time to spin up. One of their hybrid drives might be the best thing for you, as recent files will be held in flash storage and immediately available. I don't think you'll get the full performance out of an external SSD, but i could be wrong.
They have incredible customer and technical service, so if you don't get a question answered here, go direct to the source.
PSA: The above post may contain sarcasm, reply at your own risk | Not in gear database: Auto Sears 50mm 2.0 / 3x CL-360, Nikon SB-28, SunPak auto 322 D, Minolta 20