The risk was poorly-made power adapters, where 2 pins could short/arc. These cables were almost exclusively injection molded and sold through cut-rate outlets like Ali Express (and Amazon resellers of them).
Technically crimped cables are not immune, but they are rarely seen with such cost cutting. Quality molded cables are also fine, but that is very difficult to recognize or verify after purchase.
The manual should tell you the power limits, and you can cross-reference the power usage of the drives. It’s probably ok for normal consumer drives, but high-draw or enterprise drives could be an issue. You could also (probably) just get power from the PSU.