Short answer: Yes — but only if you want to sing.
In Rock Band (versions 1–4), a USB microphone is mandatory for the vocalist role. Without one, you're limited to guitar, bass, drums, or keys. The game simply won't activate the vocal track without mic input.
Any USB microphone works: Logitech, official Rock Band mics, SingStar mics, Guitar Hero mics. No proprietary hardware required.
Instrumental play? No mic needed. Vocals? Mic required. Same rule applies to Guitar Hero: Metallica and Guitar Hero: Smash Hits for their vocal modes.