To the point:
Meshroom allows you to run the whole photogrammetric pipeline. Put your images and it will generate a textured mesh automatically.
It’s mostly GUI for AliceVision framework:
AliceVision is a Photogrammetric Computer Vision framework for 3D Reconstruction and Camera Tracking.
Great thing is that they are using Alembic, OpenEXR and such, so no problem with exporting meshes. Also the Meshroom GUI is made in Python so, maybe there is a chance to integrate it with Blender itself. They have plugin for modeling in Maya.
Here are some links to read/watch more about it:
Official website: https://alicevision.github.io/
Examples on Sketchfab: AliceVision (@AliceVision) - Sketchfab
Overview with presentation in Blender: https://www.youtube.com/watch?v=NdpR6k-6SHs
Article from Scanbox: https://scanbox.xyz/blog/alicevision-opensource-photogrammetry/