Here's my contribution.
I use Smart3Dcapture (expert version). from Acute3D
I usually shoot with my Nikon D800, and focal lengths ranging from 14mm to 200mm. All work fine, even when mixed in a single project !
But I've also used the D300 (Beynac), and even my smartphone, although the picture quality of the phone isn't that good, and it appears in the scan : this sphinx was shot with my smartphone :
Sphinx statue - Hotel de Sully - Paris
The key to success is to make sure the overlap is sufficient between shots. The specification is 15° angle or less between successive shoots, and I checked that greater values just don't work.
Appart from that, any sequence of pictures is OK. For instance : the roman arena was made by wandering through and around and climbing on the monument (plus a few photos shot from a crane). 300 photos later, here's the result (shot with the D800 and the 14-24 lens at various focal lengths ) :
Perigueux : remains of the roman arena
This software can handle huge amounts of photos (depending on the version). I've scanned square kilometers at a few cm resolution, with good results (although far to big to be presented in sketchfab).
Everything's automatic, and you get a textured model with fantastic levels of detail, which can be exported to sketchfab in textured obj format.
Once it's finished, there may be a bit of retouching to do.
For the textures, I use Blacksmith3D (previously called "reality paint"), which is photoshop-like but on 3D, and very convenient to correct textures.
For the mesh itself, Autodesk's meshmixer is very easy to use, and doesn't mess up the textures (with the proper settings).
Both of these softwares readily import and export obj.
To be honnest the most difficult part when using all these softwares, is to discover, and get used to, navigation : some use LMB and different keys, some the mouse-wheel, some fonction-keys and when you switch from one to the other you end up trying to remember how to navigate.
Both mesh and textures often need to be reduced to be proprely handled by sketchfab. To decimate, I use either meshmixer or blender. To reduce textures, photoshop is fine.
Finally, a zip file with the obj, mtl and jpg file, and here it is on sketchfab !