You got some good history there.
What you have there are 4x PATA HDDs, 2x PATA ODDs and i can't make out the middle drive in HDD pile. Middle one seems to be FDD since it doesn't have standard molex for power but smaller molex connector for power, while still having PATA connector for data.
My ancient Pentium II 266 Mhz PC from 1998 uses PATA drives and has Win98SE as an OS. I still got it in working conditions.
I doubt that you get the HDDs running even if they work since you're missing jumpers on all HDDs. Jumpers on old PATA drives are needed to determinate if the drive should be master drive (e.g OS drive) or slave drive (e.g data drive). Also, you can't connect two master drives to a single PATA (aka IDE) cable if you want to...