1. Here is a chart that may help; it shows 700w and 4 6 pin power leads.
http://www.realhardtechx.com/index_archivos/Page362.htm
2. What games do you play? Some will become cpu limited.
Some do not play well with dual gpus.
To help clarify your CPU/GPU options, run these two tests:
a) Run your games, but lower your resolution and eye candy.
If your FPS increases, it indicates that your cpu is strong enough to drive a better graphics configuration.
If your FPS stays the same, you are likely more cpu limited.
b) Limit your cpu, either by reducing the OC, or, in windows power management, limit the maximum cpu% to something like 70%.
Go to control panel/power options/change plan settings/change advanced power settings/processor power management/maximum processor state/
This will simulate what a lack of cpu power will do.
Conversely what a 30% improvement in core speed might do.
You could also experiment with removing one core. You can do this in the windows msconfig boot advanced options option. set the number of processors to less than you have.
This will tell you how sensitive your games are to the benefits of many cores.
If your FPS drops significantly, it is an indicator that your cpu is the limiting factor, and a cpu upgrade is in order.
It is possible that both tests are positive, indicating that you have a well balanced system, and both cpu and gpu need to be upgraded to get better gaming FPS.
3. If your cm cooler has a 120mm fan, it is probably as good as is reasonable.
A 92mm fan will be less efficient and noisy.
On the graphics cards, the top card will get hot, particularly if your motherboard does not have an extra slot between them. But, graphics cards are built to tolerate heat.
If your case has 2 12omm intake fans at least, you should be ok.
My opinion:
Buy a single great card for a graphics upgrade. A GTX980 is very efficient and will run on a 500w psu. Sell the 7950 .
If you want a serious cpu upgrade, look for a intel haswell cpu of some sort.
Most games will only use 2-3 cores of your 6 core FX-6300.
Here is a guide, depending on your budget:
http://www.tomshardware.com/reviews/gaming-cpu-review-overclock,3106.html