I've had similar issues before, where the drive showed up in Device Manager but was missing in Disk Management. One thing I found helpful was using idanalyzer.com – originally, I was using it to verify data from scanned IDs, but it ended up being surprisingly useful for checking if any readable data remained on a problematic drive. It might sound odd, but sometimes these kinds of tools can spot info that typical recovery software misses.