Cheers for all the replies, I ended up trying what seems to be an underrated XIGMATEK Aegir. It appeared to produce good results whilst being quiet and amazingly it was stocked in my local PC World. I've got some heatsink install photos that'll I'll put up when I get a chance.
But there are problems. The heatsink itself seems good and my CPU temp is sitting at 28C but it's not quiet at all and the 120mm (4 pin) fan is blasting at 2,000rpm. So I go into BIOS and tell it to managed the CPU at 40C and the lowest fan setting to be 0%. Now it runs at 29C and about 1,100rpm. How strange. There's also a dull background thumping type sound now, not very noticable unless you tune into it - which I have
Here's another problem, the fan is attached by rubber mounts which you need to pull through and as I was doing this with the MB still attached it means I couldn't get to the lower mounts of the fan (although the CPU power cable holds it in tight so no problem). I couldn't put the fan on before mounting otherwise I'd struggle to get to the brace nuts. I couldn't be arsed pulling the whole MB out.
To be honest it doesn't sound any quieter than the stock heatsink despite the reviews and noise level quotes. If I put the fan on the memory slot side then it blocks one of the slots plus the upper side fan jams against it, so it has to go on the other side near the back which messes up the whole case airflow unless I set the full to pull air out of the heatsink rather than blow air through the heatsink (the wrong way though).
I've had to change most of the fans to create a new airflow so now the top and the upper side are the exhausts with the lower side, lower front and upper rear back being the inputs. So basically the case exhaust area is above the memory modules but I'm not really happy though. Here's what's happening now (using the old image):
I think there's too many fans and it's becoming a little noisy so I'm considering losing the heatsink fan and perhaps the lower side fan. I may put the new 4 pin CPU fan on the upper side fan and connect it to the CPU Fan controller on the mobo and get that back fan to being an exhaust again. Do you reckon the heatsink can cope without a direct fan and just the side fan to push the hot air out? I'm not massively fussed about being a few degrees hotter, I just want this bloody thing to be quiet!!!
This is certainly becoming quite the project, but kinda fun in a frustrating way.