What are the most compatible tools for models

3DS Max outputs its models as right handed models which most 3D packages use, Blender outputs models that are left handed. Unity uses the left handed coordinate system so Blend files for instance will import at the same orientation as they appear in Blender. I've found FBX models to not do this however Unity will rotate these models but you have to take this into account when setting transforms in script or you will get weird results. I've found it easier to attach your model to an empty GameObject as a parent and have the script modify the transfrom of that instead of the model itself.

Usually 3ds Max, Maya and Cinema4D all are used professionally to author models into Unity. Autodesk is more "Unity" friendly than Cinema4D or even the free software Blender. All versions have to be made Unity ready by making sure "Y" is up for Unity and also the version of FBX supported by Unity. (Eg: FBX version 2016/17 vs 2019)