I know RAM isn't supposed to effect the working state as the data should lose after a power cycle, but is there something else that could have caused the behavior?
The RAM will loose its contents right after a power cycle. You can just set the PMODE pins to F11 (OFF-ON-ON) and then power cycle. It should get you back to the bootloader.
Now to your original question: did you mean that the same firmware streams video when it was loaded from SPI Flash but not when it was loaded directly from RAM?
Ah, figured out the issue. It wasn't the RAM, some issue with the drivers.
I can boot from SPI. But the software doesnt even find the camera if I am on RAM, which I believe is the same mode as Boot mode.