Will these ever be useful on the second hand market
Nope, not ever. Even if it's standard form factor gear.
They will be disposed of ("recycled"), since that grants the largest asset depreciation tax break, and is the easiest economically. The grand majority of all data center gear gets trashed instead of reused or repurposed through the second hand market.
Source: I used to work at a hardware recycling facility, where much of the perfectly good hardware was required to be shredded, down to the components, because of these stipulations. It's such a waste.
Dumping bucket of tens of TB worth of modern RAM into a shredder is.... Infuriating.