Okay, there are external circuitry connected on the GPIO 8 and I think that might pulling the pin low, I removed it and now I am able to program it via USB, thank you so much for your help.

Yes, GPIO 8 has external 10k pullup resistor on both boards

Hello, I am made a project with ESP32-C3-MINI-1-H4 module in the past and it works great. I could program it directly from USB out of the box. But for a newer project I used ESP32-C3-MINI-1-N4 variant. As per the datasheet, The ESP32-C3FN4 chip and the ESP32-C3FH4 chip vary only in the ambient tempe...