If you are willing to "Start anew" and prepared to lose any editing done in Lightroom-Classic current messy catalog, simply Start a new Catalog and Import (using 'ADD') for all your photos in the camera folder.
Go Lr MENU: File>New Catalog. or hold down the [CTRL] key as you start Lr-Classic and select the button [Create a new Catalog]
(Later you could delete your old messy catalog!)
And never again touch your Camera files with anything other than Lr-Classic!!!
Some would suggest if many photos are not missing in the old 'Messy' catalog then - Save metadata to files - Select all and [CTRL+S]. Then an Import to the 'New' catalog, or a [Metadata / Read metadata from File] will show the photos with the previous edits.