I have used Valor DFM regularly for the final check of the PCB design before sending the files to the PCB manufacturer. Depending on the EDA tool used, the check can be useful. It is possible to find narrow copper slivers that can hinder the fabrication. Possible problems with soldermask and Legend layer(s), etc. However, Valor and other DFM tools require the definition of rule sets and it is a relatively heavy process. The same applies to HyperLynx DRC, where more advanced rules can be created from the perspective of Power Integrity and Signal integrity. However, it can be said that the result of the DFM check is completely dependent on how well the rules are defined. Unfortunately, you have to define and maintain the rules yourself. If you want to avoid unnecessary warnings or errors. you have to practically create different rule sets for Trough hole technology, HDI, Thick copper, and etc.
For a small company (no extra resources for creating/maintaining DFM rules), I recommend proper and reasonable definition of PCB design rules, so that there are no compromises in terms of manufacturability. Component libraries should also be designed carefully, taking into account PCB fabrication and PCBA manufacturing.