@adam
Does the Library view allow you to open one of those 'Missing the OPF' books?
If Calibre entry works to view those books, then the DB entry in Calibre is good as far as it points to the proper book.
To avoid confusion, do not refer to those OPF files as 'metadata' (even if they do have that name). [(B]metadata.db[/B] is what you see in the GUI.That is current ) They are supposed to only be the BACKUP of the
entry in Calibre. (Note, not much data in Calibre, that file can be pretty sparse)
Depending on How the restored DB was created:
1)If you use ADD and it saw the OPF file with the book, then tat was used.
2)otherwise, it tries to read the books internal OPF (way different than the Calibre one)
Since the metadata OPF file is missing, #2 was probably used, so what you see is what you have.

(very dim

) Open one of those books using Calibe's VIEWER. Use the View Metadata Icon (colored spokes). Does that show MORE than what Calibre has? If yes, the you might recover that books metadata. in the MDE, select the format, then click the blue book to the left. VERIFY what you see (you can always CANCEL if

) before clicking OK
Dates: Many things affect file (and metadata) dates . don't let a change lead you astray.
{date} is the date the line item creation, not the format add date (It CAN be the same)
{last_modified} ANY change that affects ANY metadata shown by Calibre FOR THAT ENTRY. Change a case on a tag in common use, and it affect all uses)