The only things I would change would be the gpu and ram.If you're not gaming or developing 3d applications all that graphics muscle is useless.You could get by even with a 5770 but because the whole build is top notch I suggest either the 5850 or 5870.Also,from the money you will have saved get more ram if you really multitask heavily.
SYSTEM USAGE FROM MOST TO LEAST IMPORTANT: Little gaming, Heavy duty multi-tasking (including development) and photo/movie editing.
First... You state "Little gaming", so I see no need to purchase the king of all Graphic Cards the 5970. It will not provide any true benefit to your needs. I would drop down to the XFX 5850 or 5870 (at most). These will provide great gaming performance for your needs and down the road you can add a second card.
Second... At a $3,000 budget, a system needs a SSD. I would highly recommend getting the OCZ Agility 2 or Vertex 2 for your OS/Apps.
Typically, I would recommend against Corsair RAM but your talk about overclocking the RAM and they are about the best when it comes to that.
I am considering like you guys said, buying a 5870 and i have thought of buying G.Skill Trident ddr3 tri-channel 2000Mhz 6GB instead of the corsair pricey solution.
as for SSD, today i tend to believe that its too early to get one for they dont implement the full potential of SATA 3.0 and are known to have some random low point of reading and writing capacity due to firmware issues.
Also, this is a bit of a personal thing but since you are going the air cooling route, may i suggest the Silverstone ft02 Fortress 2 case. Its $100 cheaper (doesn't seem to be the issue though) but has better air flow because of its 90 degree rotated MOBO design. It is also very quiet because it has foam padding and uses 3 180mm fans in the bottom and a single 120 mm exhaust at the top (so results in positive pressure and coupled with the included filters for all intake fans results in a lot less dust ending up inside the case). I coupled it with the Megahalem in a push pull and its very good in cooling. I build a system less then a month ago and was originally thinking on using the 800D but it seems that system is really build for water cooling more than air cooling. The Fortress has pretty decent cable routing too. Not as much space as the 800D on the back for the cables but if you spread the cables out, its not an issue at all. Just a thought to consider before you start building.
Well,for a budget user,it wouldn't be.But you have a budget and needs that an ssd would cover better than a better gpu.If you were a gamer the 5970 would be 10 times more useful.But since you aren't a hardcore gamer you don't need the 5970 so all the money you will save going to a 5870 or 5850 can be used for buying an ssd which would make loading your videos and photos a faster procedure.
i think 1000 wats is complete overkill unless it is a *** psu or you are geting a fermi. also for the case i have to disagree with bcubed haf 922/932 FTW!!!!! seriously it has great cooling and is big enough to fit almost anything you want in there.
Although I agree that the haf's are big, the fortress is a smidgen smaller, I still think it has better cooling and better styling (that is also similar to the 800d it its overall professional look) but again that's personal opinion. IMO, the haf series look like toys.