Yes, different failure cases (purely vision can't tell the depth of a plain white wall) but there are orders of magnitude more pixels in regular cameras. Apple's LiDAR produces a 256x192 depth map, but its RGB cameras run at 1920x1440. You get much more detail, but passive stereo is orders of magnitude slower (ToF sensors are 60 Hz, photogrammetry takes minutes.)

They complement each other well, which is the basis of our approach at Abound: combine the detail of multi-view stereo for short-range with the robustness of ToF out to 5m.