I don't have a problem with modular cables either. I mean, the cables are modular on the motherboard and hard drive end, so connectors can't be all that bad to have on the power supply end, is my way of thinking.
Generally, I recommend Seasonic or Corsair (half of which are built by Seasonic anyway) power supplies as being the right combination of good price versus good performance, but if you're willing to do research, there are a lot of good brands.
I recently replaced a power supply for a client's E-machines P4 computer with a Corsair power supply. Both were 550 watts, but the Corsair easily weighed THREE TIMES HEAVIER than the failed unit. Good components and heatsinks weigh a lot more than crummy ones.
Oh, and the Corsair power supplies have a 5-year warranty, which I think speaks pretty well of them.
-Llama