I have an old 20MB Apple SCSI hard drive from roughly 1986 I yanked from a Mac SE, its dead, maybe I could bring it back to life for you
They all make noise, just the way it is, not sure why some younger people get their panties backwards over the sound of old technology: complaining about CRTs making noise (they don't other than a buzz), HDDs, etc
My point being, old HDDs were FAR louder and more obnoxious, especially while seeking. Don't ever get a WD Black, as the one I have in my machine likes to randomly seek around loudly for no reason I can usually determine, sometimes doing so in my bios, for 3 days straight in Linux every three months randomly because of some kind of fs journaling thing I can't figure out how to disable, etc.
If you want quiet... buy a SSD
Or maybe consider a separate box you throw in a closet as a headless server, a NAS unit, or something and connect your rig and that box via router and set up NFS on the file server box, etc.