Overkill - yes
Fun - yes
The only game really that needs that type of muscle will be Crysis3, the only real use for flagship GPUs and even the 2nd teir multi GPU setups are for multimonitor or 3D gaming or in some cases 2500*1400 resolutions.
So basically, your friend is right, to much musle for 2megapixel.