Hi,
There are some interesting discussions on the forum, such as this one.
But in short, if you use the standard tool, it will have an easier time in capturing geometry details due to its unstructured nature on walls, whereas the hex-dominant tools will have a harder time due to the snapping nature of the mesh as it expands to faces.
The post that I linked focuses mostly on hex-dominant, but you should be able to find a bunch of tutorials that use the standard tool as well, such as this one and this one.