I did more testing. I tried a different adapter, the IDE -> SATA one. With this, it now doesn't work at all (yellow light with blinking red).
Furthemore, I went to try the USB IDE adapter with a different IDE drive (ASUS). It fucking died. It does not cause issues with Linux (it loaded a CD for the 30 last seconds of its life), but it's only spinning up in bursts. I also tried giving it a different power source, because that sounded like it was dying, but it made no difference (and the voltage was fine while running).
The more I touch, the more breaks. Perhaps not surprising that a drive made in 2003 stopped working in 2026, but god damn.
Edit: I could only think of 1 thing - look at the caps.
Well, there's one ribbon cable in the rear, going through a hole in the board that needs to be disconnected before I can access the top of the board. But even after removing all the screws, it wouldn't move.
It seems like their mounting method is taping it in (or did thermal pads turn into glue over time?).

Anyway...
Good news: The capacitors look fine (I couldn't safely remove the board anyway).
Bad news: The capacitors look fine (the issue isn't obvious).