4170 : games in general - yes, video/photo editing - no
it depends on what you plan on doing. games generally prefer speed as most utilize 4 cores, but a few are cropping up that can use as many as are available.
http://www.legionhardware.com/articles_pages/amd_fx_8150fx_8120fx_6100_and_fx_4170,6.html