GreatScott's post in Dead hard drive - can I change the PCB board? was marked as the answer
Never mind! I tried a different SATA port and lo and behold, there it is. Definitely some bad sectors I think but I'm able to access the files and started copying things. Whew.