Re: Cannot imagine wanting under any circumstances
Spinning rust as a storage medium has pretty much reached it's limits. I'm going to go out on a limb and predict that we never see a harddrive bigger than 20Tb in a 3.5" package.
Assuming you mean a drive containing a conventional hard disk purely electromagnetic write head, you are probably right. The physics limits for that have been reached. Magnetic domains can't be pushed closer together along the tracks (they become unstable if made any smaller), and heads cannot be made any narrower (the head would have to fly much closer, and there are power density issues even if that hurdle were overcome). Stacking tens of platters isn't likely to work either (too flexible / vibration coupling issues).
On the other hand, there's HAMR which uses a focussed laser to address a narrow track. It "softens" the magnetic film by heating it, so that a wide magnetic bubble from a conventional head operated at lower write intensity can change magnetisation only of the laser-addressed track and not affect the adjacent already-written ones. I expect that can go to many 10s, maybe 100s, of TB per 3.5 inch disk if it can get out of the lab, and if there is a market for such huge drives.
There's also BPM, about which I know less.
Wait and see. It's still possible that solid-state will obsolete all magnetic disks, but not current Flash which is also close to its physics limits. 3D flash may reach an affordable TB scale. Memristor tech has the potential to surpass that. It's rather further away than HAMR.