The video shows a full walkthrough from making a model to destroying it in Unreal Engine. Unreal has a great plugin with Apex Destruction to do this. It offers various settings you can tweak to get decent real-time simulations of destruction.
Houdini can be used here for doing custom fracturing of models. This is a strong part of Houdini and you could build complex systems, like in Borderlands 3 to get fracturing the way you want it to be.
In the video I will mainly use material fracture node, this is one node that offers a lot of settings for auto fracturing models and adding details to that.