Managed to get a CF7670C-V2 module in the end, and the available schematic only shows that WRST was replaced by HREF, which is a bit of nonsense, cause in that diagram WRST was left floating. I connected the module and all you see is noise….
Digging further, managed to find the real schematic then all become so simple and obvious: WRST was replaced by HREF on the connector, however, VSYNC is actually driving WRST directly, which means that in a normal scenario, WRST is low during the entire frame and high at te end of the frame, which is wrong unless… you can “invert” VSYNC, which is what OV7670 COM10 registry does:
Once coed changed to set bit 1 and of course change the pin from OUTPUT to INPUT, everything works fine.
For reference, bellow is the schematic with the changes between the two versions: