http://en.wikipedia.org/wiki/List_of_Intel_Core_2_microprocessorsThere are a few considerations in looking at a processor.
The ones I look at are:
Front Side Bus (FSB)
L2 Cache
Core
Internal Multiplier
VERY BASICALLY:
Front Side Bus is how fast the processor talks to the rest of the computer.
L2 Cache is high-speed memory local to the processor--it operates significantly faster than the FSB. The more it stores the less the computer is slowed down
Core is the meat of the processor. Core 2 is the fastest currently available (you can get them in duo or quad)
Internal multiplier is how many tics on the Front Side Bus does x number of cycles.
The way speed is calculated is Speed = FSB * multiplier.
a PC with a 400 Mhz bus and an internal multiplier of 5 will rate as a 2.0 Ghz machine.
a PC with a 800 Mhz bus and an internal multiplier of 2.5 will rate as a 2.0 Ghz machine.
The second of these will actually be faster under most circumstances.
If we took two devices with 800 Mhz buses and the internal multipliers of 2.5 but one had 2 MB of L2 cache, and the other had 4 MB of L2 cache the second would be faster.
With this in mind:
Look for a PC with a high front side bus speed, and a larger L2 cache. With today's multi-core processors, FSB is your real constraint, L2 cache counters that as well.
Another consideration, since you mentioned video processing, make sure you get a decent video card with at least 256 MB of On board memory. (shared MB memory is a much slower solution). I wouldn't go any lower than an Nvidia 8600 series.
If you are going to run Vista, you need a minimum of 2GB of memory or you will be wait on the memory to write out to the hard drive and back.