It sounds like many new mainboards can detect if the extra 4 ATX pins are being powered, and if so, route that power directly to the PCIe bus. If not, it branches the main 12VDC line to all accessories, including the PCIe bus.
For the everyday Joe running a low- to mid-level video card and some 3rd party PCI/PCIe card, this will be more than enough current to handle your demand. High current draw CPUs may rely more on the AUX+4 CPU power feed, but you should be okay. Only the poorest rated power supplies will get you into trouble at this point.
The trouble begins when you start installing high power drawing cards such as enthusist video cards and multiprocessor crypto engines. It is compounded if your mainboard includes a large number of chips other than the northbridge, such as auxillary SATA, sound and network processors. These chips will all fight with the PCIe bus for that 12VDC rail on the 20-pin ATX cable. The result will be instability as voltage levels drop.
Older high wattage power supplies may be able to get around the issue if your video card has an auxillary power input that can be fed through your extra molex connectors. This is how things were done with the GeForce 6800 on the AGP bus, given AGP's much lower power delivery.
I think the real problem comes down to the power supply that comes with your case. Roseville isn't a horrible company, but who knows who they OEM this power supply from. If you plan on getting this case, do not expect to use the power supply with a GeForce 6800 or any SLI configuration. It should work fine for a GeForce 6200 and 6600/6600GT as long as you're not overclocking them or adding much else to the PCI bus.