Any brand of sata cable will do.
You might want to get one with a right angle connector for your dvd burner.
Get one long enough to run from the most distant sata component to your motherboard. A bit longer is OK.
From an aesthetic point of view, you might want to match the color of the supplied motherboard cables.
From a practical point of view, I like to use different colors to more easily identify which cable goes where.
FWIW many X58 motherboards will also have legacy IDE capability.