QUOTE(clawhammer @ Jun 2 2008, 10:58 PM)
I will definitely go for modular PSU's for better cable management

Don't forget the PSU cable to wall plug is also somewhat "modular" so if connection is not good, they wouldn't have made it detachable at the first place.
hmm i guess ur right... As far as I'm concerned, the cons of modular are pretty much what people already mentioned: slightly inferior in power due eletrical resistance (but usually nothing to keep you from buying one), potential problems with the cables (if the user keeps connecting and disconnecting them too much or connect them wrong), and also being a bit pricier.
If money is no concern, the power won't be either since you just need to buy one powerful enough for your system. As for the cables, just be sure you connected everything correctly and avoid disconnecting the psu end.
The rest is mostly pure joy. Potentially better airflow, no unnecessary cables hanging in the case, ability of getting extra cables of a certain type (as long you have free slots on your PSU), and so on. But just like the cons, the advantages are not exactly earthshaking either, but handy to have