Utilizing data from Chinese A-share listed companies, this study investigates the effects of digital transformation (DT) on total factor productivity (TFP) and the moderating function of ESG performance. The results indicate that DT boosts TFP, but ESG performance negatively moderates this effect, revealing the green paradox. A dynamic model of factor allocation efficiency shows that DT improves capital allocation by reducing financing constraints, information asymmetry, and enhancing operational capacity. However, ESG weakens the positive link between DT and operational capacity, thus diminishing its impact on TFP. Similarly, DT increases labor productivity, but ESG undermines this effect by weakening the link between DT and labor efficiency. The positive impact of DT is stronger when firms focus on ‘Practical Application Technologies’ rather than ‘Underlying Technologies’. This effect is especially evident in smaller, asset-intensive, non-state-owned firms, and those located in the Beijing-Tianjin-Hebei region. Additionally, ESG’s negative moderation is more pronounced where DT exerts a stronger positive influence. A notable distinction emerges: asset-intensive firms gain more from DT in terms of TFP, whereas ESG’s adverse effect is stronger in labour-intensive firms. This study offers a novel perspective on the interplay between DT, ESG performance, and productivity. It provides valuable insights for firms seeking to align digital strategies with ESG goals, thereby fostering technological innovation alongside sustainable development.