The only reason you need these monster PSUs is simply for overclocking. Overclocking inheriently is an exponentioal power curve in the amount of power required to sustation higher and higher clocks. For a rig non-overclocked the power usage is usually very very reasonable unless you are running either 10/15k rpm hard drives, or just insane amounts of everything (pci cards, hard drives, etc).
Yes Lysawy hit the nail on the head. 400W is only the maximmum amount of DC power the PSU can supply (FYI, if you are really anal you can check the rated wattages for the various voltages 3.3v, 5v, and 12v as you may not need as much 12v wattage as say 3.3v wattage for your application, 400W is simply the total of watts available for all voltages). And the power isn't free of course all PSUs draw more AC power (in wattage) than it supplies because the conversion is inheriently inefficent, due to heat generated by the process and fans drawing power to cool the PSU.
So in reality you may only be using 200W of DC power but the PSU draws 250W of AC power. And yes the PSU inheriently draws power proportional to the amount that is being used at the time. There is a little bit of power overhead to charge capaitors in the PSU etc but generally it is very proportional.