That means your profile usage is office works, am I correct?
With moderate demand of processing power and graphics muscle, the appropriate CPU for you would be a mid-range Quad-core. I suggest an i5 from Intel or Athlon II from AMD for the starting point of your selection. The speed is not really an issue for your profile. A moderate 2.8 GHz should be sufficient. The point of having more cores is to handle several tasks at one time seamlessly.
That's the big picture. As for details, I need to ask whether you have any specific preference? Since the definition of "the latest" is a little vague, you can wait for the Llano or Sandy Bridge to be launched for that purpose. But I think it will be an overkill for your PC usage profile.
So like desktop publishing - How about this: (For photo, video editing)
Processor: core i3
Motherboard: gigabyte GA-H55N-USb3
RAM: g.skill eco 8gb
Graphics Card: Radeon HD 5970
Well you can choose a matrox editing card but it is very expensive.
Hard Drive: Western Digital 640Gb Black Caviar for OS + program
Western Digital 1Tb or 2Tb for Storage
Case:coolmaster elite 330
Power Supply: antec 430watts
A 5970 and an i3 for video editing? Switch those two around and drop in an nVidia card to get the best performance. Im just going to ignore the fact that you have a 430W PSU with a 5970 that draws 300W by itself.
I would go for an i7 950, 6GB of ram, and a GTS 450, along with a PSU that can handle it like a Corsair 550VX, it will give you much better performance since photo and video editing are much more CPU intensive than GPU intensive. The 450 is still plenty strong for anything that needs some GPU acceleration, but wont eat up a ton of the budget.