For general purpose scanning we recommend the Intel RealSense D415. It offers a good balance between the quality and the resolution of the depth and color images. In a multi-sensor setup there is no interference between the cameras which also makes it well suited for RecFusion Pro.
Orbbec Astra Mini S is another good choice, which however is good only for a single-sensor scanning due to the interference between different cameras.
In case of small object scanning, our recommendation is the Intel RealSense SR300/SR305. It provides depth measurements in as close as 30 cm to the camera, and is therefore good for capturing small details. Please be aware that it does have problems capturing very dark objects.
When the texture resolution is the priority, the best option would be the Kinect Azure, since it has 4K color image resolution.