Comparing these, the 750 W G2 does seem like a good buy, but it also seems way too big for my needs
750W is only too big in the sense that you
probably won't need to run SLI in the next 10 years. It is not too big in any other way - for a single GPU setup, there is no difference in stability compared to a 550-650W unit. And there is no difference in efficiency (that you should worry about, anyway - if there is a difference, it is minuscule).
So, it may not be worth paying extra for a 750W unit compared to an otherwise equivalent lower wattage unit. Thing is, when it comes to the 750W G2, there is no equivalent lower wattage unit, it is alone in having 10 year warranty.
However... it all boils down to whether it makes more sense to spend extra on the PSU, or on other parts. In your other thread, you said:
I might go as low as a i3 4170 (54W) with a GTX 750Ti (60W) or as high as a i5 4690 (84W) with a GTX 960 (120W).
You will be more than fine with a 450W unit, 550W tops, and you won't have to worry about noise at all.
At this wattage, you don't need a modular unit since you'll be using most cables anyway, and modularity is really not
that useful. I would much rather spend a little extra on the CPU, GPU, motherboard or SSD than pay extra for modularity.
Finally, there's little reason to pay more than ~$10 extra for Gold efficiency when running such low wattage parts, because your return of investment will be very slow. You could buy a Bronze 400W-500W unit and still run the PC quiet and stable.
Can you find prices on:
Seasonic S12II 430W
Seasonic S12II 520W
Seasonic M12II 520W
Seasonic G-450
XFX TS 550W Gold
If you could save enough on the PSU, say buy grabbing an S12II 520W, would it be within your budget limits to buy an i5-4460, a GTX 970 and a 120-250GB SSD?