I think all PSU after IDE era have SATA power connector
But usually the placement of DVD drive, HDD and SSD in a full sized ATX case means some of them cannot be reached by the cables and extension cable would be employed
Maybe a better option is to use SATA extension cable (M/F) rather than a 4 pin molex to SATA cable