Hopefully I have 2 RPi to test. I tried my camera module on one it doesn't work but it's fine on another. The one doesn't work just keep red LED on cam module in and either raspistill or raspivid hang without any image or video showing.
Anyone has idea how to check if it has H/W defect? The failed RPi I can run anything without issue any problem.