I have seen too many drives that work with the OS up but can't boot or be seen by the method you noted.

So far, we find that cleaning the CD/DVD lens and media might recover a few but after that we try a new ODD (optical disc drive.)

Only the new tech digs in their heels. Or owners.
Bob