The first post is correct in that you could run 533 MHz DDR2 ram on a non overclocked q6600 at 1:1.
However basically all modern chipsets have the ability (and this is the common situation) to run the processor at the processor's native non-overclocked speed, but to run the RAM at a higher speed asynchronously to the CPU (running the RAM at its maximum stock speed).
Looking at prices, I'd say the best value in RAM today will be had at the DDR2-800/PC2-6400 RAM which will be able to run at its full speed as above. Often this speed of ram doesn't cost much more than DDR2-667 memory, and it is a fair bit faster.
That being said, it wouldn't be horrible to use DDR2-667 memory if you find some that is a lot less expensive than the DDR2-800 stuff.
Video editing uses a lot of RAM so the more the better, I'd put in 8GB at today's prices, if running a 64 bit OS is reasonable for you (Vista 64, XP 64, LINUX, Solaris, Mac, Windows Server 2008, whatever).