The best tool I found for myself for similar goal was Devonthink. Using it for many years since and quite happy with it.

There is no AI or any other modern fad, but fulltext search (including OCR for image files inside PDFs) works great