I have my OV7670 VGA camera and Pmod working now, if not with very high image quality.
The problem I was having before with the SCCB i2c interface for configuring the camera was that I was not giving the device an x_clock signal. I thought that was only needed for camera capture but it is needed for configuration too.
You can buy the camera modules for about 2 f on ebay and you can get the PCB for the Pmod from OSH Park.
I have currently capturing the video image to dual-ported BRAM. There is only enough BRAM on the BlackIce for a 160x 120 image with two bits per colour.
So the self-portrait is not that accurate.
I will try use SRAM to capture the image but as the SRAM is not dual ported, I won't be able to do continuous capture.
Here is the current code: