The very loud jet engine sound isn't the original sound. I have one or two that are like that now, but when I got them ~1988 they were fairly quiet. There's a LisaFAQ entry about quieting them:
https://lisafaq.sunder.net/single.html#lisafaq-hw-hd-profile_too_NoisyThe one in the youtube video you link to, I'd consider fairly quiet, but it's hard to tell vs in person.
Weirdly enough these guys are very reliable. I have 4 of them, and 40 years later, they all still work. Widgets, not so much.
I luckily picked up two of them for free from a guy in Yonkers who used them on an Apple ][ and claimed that the iron oxide on them must have gotten worn out or something. Never low level formatted them or anything, just installed LOS on one, and probably Xenix on the other and they worked immediately without any issues. I'm sure they have some spared blocks, but they never gave me an issue.
The original one I had MacWorks on and was using as a Mac until I built a IIcx hackentosh, but that's another story.
Still, these days I mostly use an X/ProFIle and an Aphid as they're a lot faster.
But sound wise, yeah, that's what I remember them sounding like initially, and even today. They're noisy enough that when I was a kid living in my parent's apartment, I couldn't sleep with them on, and had to shut down the Lisa at night and the ProFile.