Effective drone detection relies on precise micro-Doppler signal detection, modulated by drone blades. For detecting small quad-rotor drones, drone detection radar bands are typically classified into two categories: resonance-type bands, such as L-band and S-band, and optical-type bands, such as Ku-band and X-band. This study compares micro-Doppler detection using L-band and X-band radar for a DJI Phantom 4 drone. The results indicate that despite L-band radar exhibiting a superior signal-to-noise ratio (SNR) (almost > 20dB) of the radar signals of drones, it surprisingly detects minimal micro-Doppler signals, while X-band radar detects nearly 100% with strong signatures. X-band radar is recommended for robust detection due to its superior performance. Given these findings, X-band radar emerges as the preferred choice than L-band radar for dependable and robust drone detection due to its heightened performance capabilities using micro-Doppler signatures.