The Corsair SF1000 (2024) wins in 4 out of 9 comparable specs, with 3 ties. Its biggest advantage is SATA Connectors (100% better).
PX1200G wins in 2 specs (Wattage: 20% better).
Recommendation
Choose SF1000 (2024) if you want the best overall performance — especially sata connectors.
Choose PX1200G if wattage matters more to you.