This was exactly my problem I had an Intel G3258 which is super over clockable but only has 2 cores. It sat for weeks indexing and wouldn't show anything. I tried loading 10 photos using the Photos web interface and it loaded them, however 2 didn't show anything other than grey boxes and all had a little loading icon running on them all the time. Clicking on them did nothing.
Finally my midrange Xeon CPU arrived (Intel Xeon E3 1240 V3) and I swapped it in and was messing around with replacing a faulty drive. I checked on the photos and moments apps shortly after this and was happily surprised to see all my photos load up really quickly.
I would vote for going on Aliexpress/Ebay and buying an old Xeon CPU. I think your Motherboard is an 1150 so the same Intel Xeon E3 1240 V3 I bought will probably fit, but CHECK your motherboard BIOS to be sure it supports it before you buy. Not all motherboards support Xeons. If you do opt for one from Aliexpress, I have bought four different CPUs from "JSF CPU Technologies Co Ltd" on four different occasions this year and all have worked well. You could also check ebay.